Question: iin this assignment you will create a forecast for a fictitious company using the attached spreadsheet template. Input the following as assumptions in the assumption

iin this assignment you will create a forecast for a fictitious company using the attached spreadsheet template. Input the following as assumptions in the assumption part of the spreadsheet (grey highlighted cells at the top of the spreadsheet) and then reference those cells when projecting the appropriate income statement, balance sheet, or break-even account. Do NOT hard code numbers into your projections. Project 20242026 Income Statement and Balance Sheet.Assumptions: Sales growth rates in each of next 3 years: 15%,25%,35% Operating expenses as % percentage of sales stays at 2023 level for 2024 then goes down by 1% in each of next two years (so, if was 20% in 2023, forecast levels would be .20,.19,.18) Cost of goods sold as % of sales stays at 2023 level for 2024 and then improves by .03 in 2025 and by another .03 in 2026(remember, this is an expense, so improves means it goes down)40% tax rate No dividends or new stock issued Interest expense fixed at $400/ year Bank loan and LT debt stay constant 2024 A/R days = year 2023 days, then decrease by 3 days in 2025 & another 3 days in 20262024 Inventory days = year 2023 days then decrease by 3 days in 2024 & another 3 days 2026 A/P days stays at year 2023 days Net fixed assets and accruals: Use 2023% of sales for 2024-2026 Required cash fixed at 1000 Calculate Additional Funds Needed as plug (to get Balance Sheet to balance!) Calculate 2024 breakeven revenues and units.Assumptions: Use line item operating expenses as fixed costs Average price per unit is $60
Please help me out . And thank you
If guys Want we can send it to my gmail .
iin this assignment you will create a forecast

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!