-state 3-year financials of an imaginary fitness center for a business plan using $100,000 as your capital and $100,000 as investment needed from an investor.
.Cash Flow, Income Statement & Balance Sheet for each
year
Year 1: Cash Flow broken down into months
Years 2 & 3: Sheets as an annual summary
Give an Opening Balance to show how much investment you need :
Startup funding |
|
Startup expense to fund |
70,000 |
Startup assets to fund |
30,000 |
Total funding required |
100,000 |
Assets |
|
Non-cash assets for startup |
100,000 |
Cash requirements for startup |
100,000 |
Additional cash raised |
0 |
Total assets |
100,000 |
Liabilities and capital |
|
Liabilities |
|
Current borrowing |
0 |
Long-term liabilities (1 year) |
60,000 |
Accounts payable (bills outstanding) |
10,000 |
Other current liabilities (interest free) |
0 |
Total liabilities |
70,000 |
Capital |
|
Planned investment |
|
Investor 1 |
100,000 |
Additional investment required |
|
Total planned investment |
100,000 |
loss at startup (startup expenses) |
20,000 |
Total capital |
100,000 |
Total capital and liabilities |
170,000 |
Startup |
|
Startup expenses |
|
Legal permits |
5,000 |
Other short term expenses |
15,000 |
Total startup expenses |
20,000 |
Startup assets |
30,000 |
Cash required |
30,000 |
Other current assets |
100,000 |
Long-term assets |
100,000 |
Total assets |
130,000 |
revenue model
Startup funding |
|
Startup expense to fund |
70,000 |
Startup assets to fund |
30,000 |
Total funding required |
100,000 |
Assets |
|
Non-cash assets for startup |
100,000 |
Cash requirements for startup |
100,000 |
Additional cash raised |
0 |
Total assets |
100,000 |
Liabilities and capital |
|
Liabilities |
|
Current borrowing |
0 |
Long-term liabilities (1 year) |
60,000 |
Accounts payable (bills outstanding) |
10,000 |
Other current liabilities (interest free) |
0 |
Total liabilities |
70,000 |
Capital |
|
Planned investment |
|
Investor 1 |
100,000 |
Additional investment required |
|
Total planned investment |
100,000 |
loss at startup (startup expenses) |
20,000 |
Total capital |
100,000 |
Total capital and liabilities |
170,000 |
Startup |
|
Startup expenses |
|
Legal permits |
5,000 |
Other short term expenses |
15,000 |
Total startup expenses |
20,000 |
Startup assets |
30,000 |
Cash required |
30,000 |
Other current assets |
100,000 |
Long-term assets |
100,000 |
Total assets |
130,000 |
-state 3-year financials of an imaginary fitness center for a business plan using $100,000 as your...
1. Based on the following data, what is the amount of working capital? Accounts payable....................$32,000 Accounts receivable....................64,000 Accrued liabilities....................7,000 Cash.........................................20,000 Intangible assets............................40,000 Inventory...............................................72,000 Long-term investments...............................100,000 Long-term liabilities.....................................75,000 Marketable securities.................................35,000 Notes payable (short-term)........................20,000 Property, plant, and equipment.................625,000 Prepaid expenses.........................................2,000 WHAT IS WORKING CAPITAL? a. $162,000 b. $134,000 c. $193,000 d. $62,000 2. Use the following data to determine the total dollar amount of assets to be classified as current assets. Cash..............................................$60,000 Prepaid insurance..........................40,000 Accounts receivable......................50,000 Inventory.........................................70,000 Land held for investment................80,000 Land................................................95,000...
Prepare a statement of Cash Flow for the current year using
the indirect method
Robust Robots, Inc. Comparative Balance Sheet December 31, 2019 and 2018 2019 2018 Assets Current Assets: Cash Accounts Receivable, net Merchandise Inventory Supplies Prepaid Insurance Total Current Assets $ $ $ $ $ $ 65,000 150,000 135,000 9,700 30,000 389,700 $ $ $ $ $ $ 80,000 100,000 70,000 500 10,000 260,500 Property, Plant, and Equipment: Equipment Less: Accumulated Depreciation - Equipment Total Property, plant, and...
Prepare a Statement of Cash Flow for the current year using
the indirect method
Robust Robots, Inc. Comparative Balance Sheet December 31, 2019 and 2018 2019 2018 Assets Current Assets: Cash Accounts Receivable, net Merchandise Inventory Supplies Prepaid Insurance Total Current Assets $ $ $ $ $ $ 65,000 150,000 135,000 9,700 30,000 389,700 $ $ $ $ $ $ 80,000 100,000 70,000 500 10,000 260,500 Property, Plant, and Equipment: Equipment Less: Accumulated Depreciation - Equipment Total Property, plant, and...
THE ANSWER IS NOT COMPLETE I DONT KNOW WHY (I DARE TO KNOW THE
REASON ;)
Problem 3-3 Balance sheet preparation [LO3-2, 3-3]
The following is a December 31, 2018, post-closing trial balance
for Almway Corporation.
Account Title
Debits
Credits
Cash
$
45,000
Investments
110,000
Accounts receivable
60,000
Inventories
200,000
Prepaid insurance (for the next 9 months)
9,000
Land
90,000
Buildings
420,000
Accumulated depreciation—buildings
$
100,000
Equipment
110,000
Accumulated depreciation—equipment
60,000
Patents (net of amortization)
10,000
Accounts payable
75,000
Notes...
Prepare Statement of cash flows for current year using indirect
method.
Dynamic Drones Comparative Balance Sheet December 31, 2019 and 2018 2019 2018 Assets Current Assets: Cash Accounts Receivable, Net Merchandise Inventory Prepaid Rent Total Current Assets $60,000 $140,000 $110,000 $20,000 $330,000 $80,000 $100,000 $70,000 $10,000 $260,000 Property, plant, and Equipment: Equipment $400,000 Less: Accumulated Depreciation - Equipment ($60,000) Total Property, Plant, and Equipment $340,000 Total Assets $670,000 $191,000 ($42,400) $148,600 $408,600 2019 2018 Liabilities and Stockholders' Equity Current Liabilities:...
The Dawson Company has just completed a number of budgets for the coming year. The cost of goods manufactured schedule, the pro forma income statement, and the balance sheet still have to be completed. The following information is available as 12/31/X8. Prior Year Balance Sheet Assets Cash $45,000 Accounts Receivable $55,000 Materials Inventory $40,000 Work-in-Process Inventory $30,000 Finished Goods Inventory $36,000 Prepaid Expenses $20,000 Plant and Equipment $500,000 Accumulated Depreciation ($140,000) Other Assets $22,000 Total Assets $608,000 Liabilities and Equity...
Selected accounts from the Pearson, Gomez, and Litt Partnership adjusted trial balance for the year ended Accounts payable Cash Land Pearson, Capital $ 5,000 40,000 25,000 30,000 Accounts receivable Gomez, Capital Long-term notes payable Litt, Capital $10,000 15,000 20,000 5,000 Prepare a classified balance sheet. PEARSON, GOMEZ, AND LITT PARTNERSHIP Balance Sheet December 31 Assets Current assets Total current assets Plant assets Total assets Liabilities Current liabilities Long-term liabilities Selected accounts from the Pearson, Gomez, and Litt Partnership adjusted trial...
The Statement of Cash Flows 215 Problem 14 sed balance sheets of the Spartan Inn are as follows: The condensed bala Spartan Inn Condensed Balance Sheets December 31, 20X1 and 20X2 20X1 Assets Current Assets: 20X2 Cash $ $ Marketable Securities Accounts Receivable Inventory Total Current Assets Investments Property and Equipment: 30,000 50,000 100,000 20,000 200,000 100,000 40,000 50,000 95,000 25,000 210,000 60,000 500,000 5,000,000 1,000,000 (1,600,000) 4,900,000 $5,200,000 500,000 6,000,000 1,100,000 (2,000,000) 5,600,000 $5,870,000 Land Building Equipment Accumulated Depreciation...
Part C: WACC and Capital Budgeting Calculate the firm’s WACC
(using 2018 numbers). (You will need to collect information on the
long-term debt and common stock equity from the Balance Sheet. The
firm has no preferred stock). Use the WACC to calculate NPV and
evaluate IRR for proposed capital budgeting projects. Assume the
projects are mutually exclusive and the firm has the money
available to fund the project.
Part D: Analysis You will must offer suggests to a senior
financial...
Free Cash flow question
What is the amount of free cash flow for this company for the
year? Please show formula/equation so i know how to solve for.
Thank you!
Cash Flow Statement Amount Calculations - Chapter 14 End of year Beginning of year Current year Income statement Balance sheet Cash Accounts receivable Inventory Prepaid expenses Total current assets Equipment, at cost Less: Accum. depreciation Net equipment Total assets 86,000 112,000 141,000 18,000 357,000 298,000 (100,000) 198,000 555,000 54,000 126,000...