FILE: Business & Finance Verified Expert Solution

Prepare a financial forecast

Problem Statement / Requirements:

You are the new financial manager of Northern Chemicals Ltd, a Kitale producer of specialized chemicals for use in fruit orchards. Yo are in the process of preparing a financial forecast for 2022. The company's sales revenue for 2021 was $ 2 billion, and the marketing department is forecasting a 25% increase for 2022. You think that the company was operating at full capacity in 2021 but you are not sure about this. The interest rate on debt is 8%. The 2021 financial statements are shown below. 2021 Balance Sheet (in millions) % of Sales Cash and Securities $20 1% Accounts Receivable $240 12% Inventories $240 12% Total Current Assets $500 Net Fixed Assets $500 25% Total Assets $1,000 Accounts Payable and Accruals $100 5% Notes Payable $100 Total Current Liabilities $200 Long Term Debt $100 Common Stock $500 Retained Earnings $200 Total Liabilities and Equity $1,000 2021 Income Statement (in millions) % of Sales Sales $2,000 Variable Costs $1,200 60% Fixed Costs $700 35% EBIT $100 Interest $16 EBT $84 Taxes(40%) $33.60 Net Income $50.40 Dividends(30%) $15.12 Additions to Retained Earnings $35.28 Required: a) Prepare a financial forecast for 2022 assuming that the company was operating at full capacity       in 2021. (10 marks) b) Assuming that in 2021, fixed assets had been operated at only 75% of capacity and that sales is      expected to increase to $3,000 million and not $2,500 million in 2022, calculate the fixed assets      requirement for 2022. Show all the workings. (10 marks)
Expert Business Solution Preview for Prepare a financial forecast

Verified Audit File

Calculations & Analysis Included

ACCESS FULL AUDIT
✓ Accrual Accuracy ✓ Scholarly Reference ✓ PLAG-Zero

The EconHelp Precision Audit

01. Mathematical Rigor

Every derivation and calculation is checked for logic and accuracy by a subject matter expert.

02. Current Data sets

We use the latest financial indicators and economic reports to ensure your analysis is relevant to the current market.

03. Perfect Referencing

Full citations for every theoretical framework and data point used in the analysis.

04. Case Specific Logic

Tailored explanations that address the specific nuances of the business scenario provided.

Technical Help FAQ: Business & Finance

How can I learn from this business study?

Review the step-by-step calculations and the way theories are applied to the specific case data. Use the cited seminal works to further your own research and deepen your understanding of Business & Finance principles.

Do you handle Excel-based financial modeling for this topic?

Yes. For assignments in Business & Finance, we can provide professional Excel workbooks with clear cell-referencing and dynamic formulas that show the underlying logic of the financial projections.

Related Audit Logs

Business & Finance

Capstone W4 Term Paper

The segment referred to as a review of the literature is intended as a starting point for your research. In effect, you should research what other experts and commentators have already analyzed with respect to the problem you are scrutinizing.

Business & Finance

Alternative Fuel Company Case

A start-up alternative fuel automobile company has a first year market forecast of 1000 units. Identify the forecasting model that is in use here and explain why it is the obvious choice.

Business & Finance

Case Study on unemployment 4-6 pages

In this assignment, you need to identify only two specific issues related to unemployment. You will study their past trends, provide an overview of their current status, and provide solutions to overcome them. You will use data, articles, experts' opinions, and government reports to draw a clear picture of the current unemployment issues. Some areas you might consider are the following (based on gender, education, race, age):  · Unemployment rates among young college graduates · Unemployment rates for women · Unemployment rates for men · Unemployment rates among African Americans · Unemploymen...

Business & Finance

Assessment 1 -Revision

Complete the Vila Health: Health Information Technology Needs Analysis interactive simulation, linked in the Resources. Gather information about the IT needs of various departments within the hospital that will support a needs assessment.

Business & Finance

Wk 5, MHA 508: DR 1

APA format Cite one peer reviewed reference 175-265 words Respond to the following: Christie Artuso When we do consider all of the 'good' that has been accomplished through these cells (HeLa cells) - it might be prudent to ask - if she DID have the right to consent (at that time) - and she said 'no' - what would the outcome have been? Would we have done to 'discover' these opportunities - if anything? Henrietta Lacks was not directly harmed by the use of her cells - and at that time - treatment was very limited (and it seems that her cancer had advanced significantly as well. Does it make sen...

Business & Finance

Business analysis project

I am looking for help in preparing the document for my final project in Business Analysis subject. I have attached the details of the project in the below documents. The documents attached below are my team project proposal, an information document about the project and also a sample template. The document is supposed to be made exactly as the sample document given which include the same side headings and also the model.

Business & Finance

MKT/574 WEEK 5: Apply: Digital and Social Media Strategies Presentation

Many digital and social media sites are widely used in marketing strategies. Prepare a 10- to 15-slide presentation with detailed speaker’s notes and visuals elements. Complete the following in your presentation: Identify a company that could benefit from better use of social media. Analyze at least 10 digital and social media channels and describe the strengths and weaknesses of each of these as a marketing tool for this company. Design an online strategy that maximizes the use of some or all of the digital and social media channels, as appropriate, based on...

Business & Finance

Disney New Product

Create a PowerPoint presentation about future inventions this new product could help to inspire and what innovations could be developed to enhance and improve this product. Analyze how these two areas could impact DISNEY. Your PowerPoint presentation should include the following elements:

Business & Finance

business

The component of compensation in a compensation system can either be monetary or non-monetary benefits. What are the monetary benefits? and non-monetary benefits? Explain with relevant examples.             N.B. the assignment should be not more than five pages with references.