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.Question: Using the Score Financial Projections Template (See Below) analyze the picturesPart 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!