Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting For Beginners

Authors: Andry Gordon

1st Edition

1675164045, 978-1675164044

More Books

Students also viewed these Accounting questions