The template we use can be found at https://www.score.org/resource/financial-projections-template The pictures shown are what we put inot the template during the class.

I broke down this question in to parts as you can see in the list of questions I have asked. The excel document did not copy over very well. So I have attached all the tabs by picture to this question. You might have to zoom in to see the numbers better. At the bottom of each picture it gives what the tab was labeled in the excel document. If whoever is looking at this would like the excel document I can send that to you no problem. I ran out of questions for the period by breaking down each section by part. If you have any questions please let me know.

Here is the querstion:

Using the Score Financial Projections Template (See Pictures Below) analyze the pictures in their entirety for any aspects that may not be obvious to the common financial statement user. Explain each of these areas of possible confusion. Please label each section of confusion by the label at the bottom of the picture. Also, Include assumptions regarding financial statement content for the following sections and time periods Pro-forma: Sales forecast, Income Statement monthly for the first year, Income Statement yearly for the first three years, Balance Sheet At the end of your first fiscal year and Statement of Cash Flows monthly for the first year.

Start-Up Expenses Year I (Starting Balance Sheet) No Estate-Land 4000 20 Real Estate Buildings 20,000 7 Leasehold Imp 5.000 7 Equipm 30,000 niture and Fixtures Vehicles Other 0000 Total Fixed Assets Operatingompial Amount Notes Pre-opening Salaries and W Prepaid insurance Premiums 7000 Inventory Legal and Accounting Fee Rent Deposit 3,000 Utility Deposits Supplie 3,000 Advertising d P 3,000 Licenses nitial Start-Up Costs Working Capital (Cash On Hand Tota operating Capita 3 Total Required Funds Sources Funding Fercentage Locals Loan Ratel Term in Months Monthly Payments Notes 3X Owner's Equity 60,000 Outside Investors 4694 Addicional Loans or Deb Commercial Loan Commercial Mortgage 240 Credic Card Deb 000A 601 Other Bank Debt Total Sources of Funding IOOOOX S II 4,694 Cell D 2nmust equal cell C3 3 Total Funding Needed 5 You are fuly unded Balanced ONLY Cash on H Cash Precald Expensas A&counts Total Cash on Hand I-Starting Point Start-Up Expenses Year I (Starting Balance Sheet) No Estate-Land 4000 20 Real Estate Buildings 20,000 7 Leasehold Imp 5.000 7 Equipm 30,000 niture and Fixtures Vehicles Other 0000 Total Fixed Assets Operatingompial Amount Notes Pre-opening Salaries and W Prepaid insurance Premiums 7000 Inventory Legal and Accounting Fee Rent Deposit 3,000 Utility Deposits Supplie 3,000 Advertising d P 3,000 Licenses nitial Start-Up Costs Working Capital (Cash On Hand Tota operating Capita 3 Total Required Funds Sources Funding Fercentage Locals Loan Ratel Term in Months Monthly Payments Notes 3X Owner's Equity 60,000 Outside Investors 4694 Addicional Loans or Deb Commercial Loan Commercial Mortgage 240 Credic Card Deb 000A 601 Other Bank Debt Total Sources of Funding IOOOOX S II 4,694 Cell D 2nmust equal cell C3 3 Total Funding Needed 5 You are fuly unded Balanced ONLY Cash on H Cash Precald Expensas A&counts Total Cash on Hand I-Starting Point