Question

1 Approved Answer

Posted on Jul 30, 2024

Please use the template provided to develop a sample forecast. It can be from a company or business or you can create the numbers. You

image text in transcribed Please use the template provided to develop a sample forecast. It can be from a company or business or you can create the numbers. You only need to do the orange boxes

image text in transcribed

Assumptions Opening Year 1 Year 2 Year 3 Year 4 Year 5 0 0 0 0 0 0 0 45 0 0 0 0 0 Balance sheet Assets Cash Accounts receivable Inventory Current assets Long-term assets Total assets 90 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Liabilities Accounts payable Other liabilities Current liabilities Long-term debt Total liabilities 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O 0 0 0 0 0 0 Equity Capital Retained earnings Total equity Total liabilities and equity 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Income Statement Assumptions Year 1 Year 2 Year 3 Year 4 Year 5 0 0 0 0 0 0.0% 0.0% 0.0% 0.0% 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Revenue Gross margin % Cost of sales Gross margin Research and development Sales and marketing General and administrative Operating expenses Depreciation Operating income Finance costs Income before tax Income tax expense Net income 0 0 0 0 0.0% 0 0 0 0 0 0 0 0 0 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0.0% 0 0 0 0 O 0 0 0 0 Assumptions Opening Year 1 Year 2 Year 3 Year 4 Year 5 0 0 0 0 0 0 45 0 0 0 0 0 0 Balance sheet Assets Cash Accounts receivable Inventory Current assets Long-term assets Total assets 90 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Income Statement Assumption Year 1 Year 2 Year Year 4 Years Input 0 0 0.00 0.00 D. ol ol 0 D D 0 0 0 Peren Grommer Contatos Groningin Pearch and development Sales and marketing General and administratta Operating per Deprecat Operating income Take on Income before tax Incorper Net Income DO 0 D 0 DO DO Darwinning balance bet D D DO 0 D 0 D 0 D 0 DO 0 D 0 DO DO D DO o Asumption Opening Year 1 Year 2 Year Year 4 Balance sheet AS Years 0 D of 0 0 0 ol 90 D 0 D 0 ol Accounts receivable wy Current Long ol 0 0 D ol D D 0 0 0 Total asuta D D 0 0 0 ol Liabilities Accounts pa Other librat Current abilities Long-term deb Total 0 0 D o D 0 D 0 o er them to your wichtheping to be cleared, and the price D DO D D Equity Capital Retained ning O 0 0 of DO 0 0 o 0 D D DO D DO Total and Cash Flow Statement Muration Year 1 Year Year Year Years 0 0 0 0 o 0 0 Nation Add wediation Changes in working capital Accounts receivable tary Accounts payable Other labrati Cash flows from pering activities 0 o O 0 0 0 0 D DO D DO D Amount paid for long-term us Cash flow from iting activities D D D D Det them is yer which wach want to be red, and the new debe Proceeds from lang-car debt Proceeds from of the cap Pepayment of long-term diebt Cash flow frem tirunding activities 0 0 D 0 D D DO D D DO 0 Cash flow Daging chance Ending cash balance D 0 D 0 ol Assumptions Opening Year 1 Year 2 Year 3 Year 4 Year 5 0 0 0 0 0 0 0 45 0 0 0 0 0 Balance sheet Assets Cash Accounts receivable Inventory Current assets Long-term assets Total assets 90 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Liabilities Accounts payable Other liabilities Current liabilities Long-term debt Total liabilities 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O 0 0 0 0 0 0 Equity Capital Retained earnings Total equity Total liabilities and equity 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Income Statement Assumptions Year 1 Year 2 Year 3 Year 4 Year 5 0 0 0 0 0 0.0% 0.0% 0.0% 0.0% 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Revenue Gross margin % Cost of sales Gross margin Research and development Sales and marketing General and administrative Operating expenses Depreciation Operating income Finance costs Income before tax Income tax expense Net income 0 0 0 0 0.0% 0 0 0 0 0 0 0 0 0 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0.0% 0 0 0 0 O 0 0 0 0 Assumptions Opening Year 1 Year 2 Year 3 Year 4 Year 5 0 0 0 0 0 0 45 0 0 0 0 0 0 Balance sheet Assets Cash Accounts receivable Inventory Current assets Long-term assets Total assets 90 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Income Statement Assumption Year 1 Year 2 Year Year 4 Years Input 0 0 0.00 0.00 D. ol ol 0 D D 0 0 0 Peren Grommer Contatos Groningin Pearch and development Sales and marketing General and administratta Operating per Deprecat Operating income Take on Income before tax Incorper Net Income DO 0 D 0 DO DO Darwinning balance bet D D DO 0 D 0 D 0 D 0 DO 0 D 0 DO DO D DO o Asumption Opening Year 1 Year 2 Year Year 4 Balance sheet AS Years 0 D of 0 0 0 ol 90 D 0 D 0 ol Accounts receivable wy Current Long ol 0 0 D ol D D 0 0 0 Total asuta D D 0 0 0 ol Liabilities Accounts pa Other librat Current abilities Long-term deb Total 0 0 D o D 0 D 0 o er them to your wichtheping to be cleared, and the price D DO D D Equity Capital Retained ning O 0 0 of DO 0 0 o 0 D D DO D DO Total and Cash Flow Statement Muration Year 1 Year Year Year Years 0 0 0 0 o 0 0 Nation Add wediation Changes in working capital Accounts receivable tary Accounts payable Other labrati Cash flows from pering activities 0 o O 0 0 0 0 D DO D DO D Amount paid for long-term us Cash flow from iting activities D D D D Det them is yer which wach want to be red, and the new debe Proceeds from lang-car debt Proceeds from of the cap Pepayment of long-term diebt Cash flow frem tirunding activities 0 0 D 0 D D DO D D DO 0 Cash flow Daging chance Ending cash balance D 0 D 0 ol