Question
Part 1 Using the Score Financial Projections Template (See Below) analyze the pictures in their entirety for any aspects that may not be obvious to
Part 1 Using the Score Financial Projections Template (See 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 highlighted label on each excel sheet. The spreadsheet did not show up on word like I wanted it to. If the person looking at this would like a copy of the excel spreadsheet I would be happy to send it to them.
Start-up Expenses Year 1 (Starting Balance Sheet) | |||||||
Prepared By: | Company Name: | ||||||
Owner | Company 1 | ||||||
Fixed Assets | Amount | Depreciation (years) | Notes |
| |||
|
|
|
|
| |||
Real Estate-Land | - | Not Depreciated |
|
| |||
Real Estate-Buildings | 4,000 | 20 |
|
| |||
Leasehold Improvements | 20,000 | 7 |
|
| |||
Equipment | 5,000 | 7 |
|
| |||
Furniture and Fixtures | 30,000 | 5 |
|
| |||
Vehicles | 1,000 | 5 |
|
| |||
Other | - | 5 |
|
| |||
Total Fixed Assets | $ 60,000 |
|
|
| |||
|
| ||||||
Operating Capital | Amount | Notes | |||||
Pre-Opening Salaries and Wages | 26,094 |
| |||||
Prepaid Insurance Premiums | 7,000 |
| |||||
Inventory | 8,000 |
| |||||
Legal and Accounting Fees | 1,000 |
| |||||
Rent Deposits | 3,000 |
| |||||
Utility Deposits | 600 |
| |||||
Supplies | 3,000 |
| |||||
Advertising and Promotions | 3,000 |
| |||||
Licenses | 1,000 |
| |||||
Other Initial Start-Up Costs | 2,000 |
| |||||
Working Capital (Cash On Hand) | - |
| |||||
Total Operating Capital | $ 54,694 |
| |||||
Total Required Funds | $ 114,694 |
| |||||
Sources of Funding | Percentage | Totals | Loan Rate | Term in Months | Monthly Payments | Notes | |
Owner's Equity | 52.31% | 60,000 |
|
|
|
| |
Outside Investors | 21.53% | 24,694 |
|
|
|
| |
Additional Loans or Debt |
|
|
|
|
|
| |
Commercial Loan | 26.16% | 30,000 | 9.00% | 84 | 483 |
| |
Commercial Mortgage | 0.00% | - | 9.00% | 240 | - |
| |
Credit Card Debt | 0.00% | - | 7.00% | 60 | - |
| |
Vehicle Loans | 0.00% | - | 6.00% | 48 | - |
| |
Other Bank Debt | 0.00% | - | 5.00% | 36 | - |
| |
Total Sources of Funding | 100.00% | $ 114,694 | Cell D 42 must equal cell C31 | $ 483 |
| ||
Total Funding Needed |
| $ - | You are fully funded (Balanced) |
|
Step 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