Question: Question: Using the Score Financial Projections Template (See Below) analyze the pictures in their entirety for any aspects that may not be obvious to the
Question: 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.
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.
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.
Part 8 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.
| Operating Expenses Year 1 | |||||||||||
| Prepared By: | Company Name: | ||||||||||
| Owner | Company 1 | ||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | ||
| Expenses | |||||||||||
| Advertising | 354 | 354 | 354 | 354 | 354 | 354 | 354 | 354 | 354 | 354 | |
| Car and Truck Expenses | - | - | - | - | - | - | - | - | - | - | |
| Commissions and Fees | - | - | - | - | - | - | - | - | - | - | |
| Contract Labor (Not included in payroll) | - | - | - | - | - | - | - | - | - | - | |
| Insurance (other than health) | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | |
| Legal and Professional Services | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | |
| Licenses | - | - | - | - | - | - | - | - | - | - | |
| Office Expense | - | - | - | - | - | - | - | - | - | - | |
| Rent or Lease -- Vehicles, Machinery, Equipment | - | - | - | - | - | - | - | - | - | - | |
| Rent or Lease -- Other Business Property | - | - | - | - | - | - | - | - | - | - | |
| Repairs and Maintenance | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | |
| Supplies | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | |
| Travel, Meals and Entertainment | - | - | - | - | - | - | - | - | - | - | |
| Utilities | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | |
| Miscellaneous | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | |
| Total Expenses | $ 1,794 | $ 1,794 | $ 1,794 | $ 1,794 | $ 1,794 | $ 1,794 | $ 1,794 | $ 1,794 | $ 1,794 | $ 1,794 | |
| Other Expenses | |||||||||||
| Depreciation | 831 | 870 | 910 | 949 | 988 | 1,027 | 1,067 | 1,106 | 1,145 | 1,185 | |
| Interest | |||||||||||
| Commercial Loan | 225 | 223 | 221 | 219 | 217 | 215 | 213 | 211 | 209 | 207 | |
| Commercial Mortgage | - | - | - | - | - | - | - | - | - | - | |
| Credit Card Debt | - | - | - | - | - | - | - | - | - | - | |
| Vehicle Loans | - | - | - | - | - | - | - | - | - | - | |
| Other Bank Debt | - | - | - | - | - | - | - | - | - | - | |
| Line of Credit | - | 40 | 27 | 14 | 1 | (12) | (26) | (39) | (52) | (65) | |
| Bad Debt Expense | (148,909) | (120,420) | (125,119) | (129,571) | (124,168) | (123,934) | (132,357) | (125,088) | (126,509) | (130,047) | |
| Total Other Expenses | $ (147,853) | $ (119,286) | $ (123,961) | $ (128,389) | $ (122,962) | $ (122,704) | $ (131,103) | $ (123,810) | $ (125,207) | $ (128,720) | |
| Total Fixed Operating Expenses | $ (146,059) | $ (117,492) | $ (122,167) | $ (126,595) | $ (121,168) | $ (120,910) | $ (129,309) | $ (122,016) | $ (123,413) | $ (126,926) | |
operating Expenses Years l-3 2017 Growth Rate to 2 2018 Growth Rate 2 to 3 2019 Line Item 4.248 4,375 Advertising .0%. 4,507 Car and Truck Expenses .0%. Commissions and Fees 5.0% 5.0% 3.0% Contract Labor (Not included in payroll) .0%. .080 Insurance (other than health) 3600 Legal and Professional Services 3.0% 3,708 3.0% 3,819 License 5.0% 5.0% Office Expense 30% 0%. Rent or Lease Vehicles, Machinery, Equipment 3.0% 3.0% Rent or Lease Other Business Property 3.0% 3.0 5.0% 260 5.0% .323 Repairs and Maintenance Supplies 3600 3.0% 3,708 3.0% 3,819 Travel Meals and Entertainment 3.0% 30% Utilities 3,000 3,090 Miscellaneous 5,092 3 22,198 22.889 Total Expenses Other Expenses 157 12,564 Depreciation Interest Commercial Loan 2,569 2,267 Commercial Mortgages CreditCard Debt vehiclo Loans Other Bank Debt Line of Cred 28 O2.12) (4019) Bad Dobt Expense (.5%8980 Total Other Expenses (.582,046) S 3 15.30 S 13.075 S (L560,518) 37,499 35,964 Total operating Expenses 5b-OpExYrs I-3 operating Expenses Years l-3 2017 Growth Rate to 2 2018 Growth Rate 2 to 3 2019 Line Item 4.248 4,375 Advertising .0%. 4,507 Car and Truck Expenses .0%. Commissions and Fees 5.0% 5.0% 3.0% Contract Labor (Not included in payroll) .0%. .080 Insurance (other than health) 3600 Legal and Professional Services 3.0% 3,708 3.0% 3,819 License 5.0% 5.0% Office Expense 30% 0%. Rent or Lease Vehicles, Machinery, Equipment 3.0% 3.0% Rent or Lease Other Business Property 3.0% 3.0 5.0% 260 5.0% .323 Repairs and Maintenance Supplies 3600 3.0% 3,708 3.0% 3,819 Travel Meals and Entertainment 3.0% 30% Utilities 3,000 3,090 Miscellaneous 5,092 3 22,198 22.889 Total Expenses Other Expenses 157 12,564 Depreciation Interest Commercial Loan 2,569 2,267 Commercial Mortgages CreditCard Debt vehiclo Loans Other Bank Debt Line of Cred 28 O2.12) (4019) Bad Dobt Expense (.5%8980 Total Other Expenses (.582,046) S 3 15.30 S 13.075 S (L560,518) 37,499 35,964 Total operating Expenses 5b-OpExYrs I-3
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
