Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the financial modeling Excel template and individual tabs, create a pro-forma profit and loss forecast, cash flow analysis and projected balance sheets for the

Using the financial modeling Excel template and individual tabs, create a pro-forma profit and loss forecast, cash flow analysis and projected balance sheets for the first 3 years of the business. In the Notes column for each forecasted statement, replace the instruction notes with assumptions, descriptions of the items included for each row and any other comments to support and justify the numbers used. Assignments are to include the completed Microsoft Excel template file, as well as any additional spreadsheets used to calculate more detailed business data like product costs or potential revenue forecasts.

image text in transcribed

Projected Balance Sheet Year 1 Year 2 Year 3 Notes - replace instructional notes with your business specific notes and assumptions. Assets Current Assets Cash . 7 Ending cash balance from cash flow Joutstanding balance at end of year - amount customers owe you for products sold Estimate value of inventory on hand - finished and unfinished (raw materials) goods 1 50,000 $ 2$ Land is not depreciable Building depreciate over 30 years, so 1/30 of building cost $ $ . Inventory Total Current Assets $ Fixed Assets Land Buildings Less Depreciation Total Buildings Equipment Less Depreciation Total Equipment $ Furniture and Fixtures $ Less Depreciation Total Furniture and Fixtures $ Total Fixed Assets $ Total Assets $ use 1/15 of original cost for equipment depreciation $ $ $ $ . 5 1 1 Use 1/10 of original cost for any furntiure and fixture items 5 $ 5 $ 50,005 $ $ 1 $ 3$ 1 1 8 Amount that you owe vendors who provide product (not loans) Amount of debt due in the next 12 months, lines of credit, etc... $ - $ - $ - Liabilities Current Liabilities Accounts Payable Current Portion of Long Term Debt Total Current Liabilities Long-term Liabilities Mortgage Other Long-term Loans Total Long-term Liabilities Total Liabilities Loans on buildings Long term portion on other loans (amoutn due after next 12 months) - - $ $ . - $ $ Total Owner's Equity Total Liabilities and Owner's Equity $ $ 50,005 $ 50,005 $ 3 $ 3$ 8 8 Note: Input numbers into unshaded boxes

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions