Question
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.
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 boxesStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started