#36
|
Category |
Prior year |
Current year |
|
Accounts payable |
41,400 |
45,000 |
|
Accounts receivable |
115,200 |
122,400 |
|
Accruals |
16,200 |
13,500 |
|
Additional paid in capital |
200,000 |
216,660 |
|
Cash |
??? |
??? |
|
Common Stock @ par value |
37,600 |
42,000 |
|
COGS |
131,400 |
178,048.00 |
|
Depreciation expense |
21,600 |
23,454.00 |
|
Interest expense |
16,200 |
16,239.00 |
|
Inventories |
111,600 |
115,200 |
|
Long-term debt |
135,000 |
138,220.00 |
|
Net fixed assets |
378,033.00 |
399,600 |
|
Notes payable |
59,400 |
64,800 |
|
Operating expenses (excl. depr.) |
50,400 |
63,396.00 |
|
Retained earnings |
122,400 |
136,800 |
|
Sales |
255,600 |
335,268.00 |
|
Taxes |
9,900 |
19,449.00 |
What is the current year's cash balance?
Submit
Answer format: Number: Round to: 0 decimal places.
In: Finance
| Item | Prior year | Current year |
| Accounts payable | 8,162.00 | 7,764.00 |
| Accounts receivable | 6,037.00 | 6,505.00 |
| Accruals | 971.00 | 1,604.00 |
| Cash | ??? | ??? |
| Common Stock | 10,285.00 | 11,181.00 |
| COGS | 12,756.00 | 18,092.00 |
| Current portion long-term debt | 5,000.00 | 4,987.00 |
| Depreciation expense | 2,500 | 2,821.00 |
| Interest expense | 733 | 417 |
| Inventories | 4,235.00 | 4,808.00 |
| Long-term debt | 13,375.00 | 13,279.00 |
| Net fixed assets | 50,876.00 | 54,507.00 |
| Notes payable | 4,342.00 | 9,971.00 |
| Operating expenses (excl. depr.) | 13,977 | 18,172 |
| Retained earnings | 28,534.00 | 29,642.00 |
| Sales | 35,119 | 45,401.00 |
| Taxes | 2,084 | 2,775 |
What is the firm's dividend payment in the current year?
What is the firm's cash flow from operations?
What is the firm's cash flow from financing?
What is the firm's cash flow from investing?
What is the firm's total change in cash from the prior year to the
current year?
What is the value today of a money machine that will pay $2,300.00 per year for 27.00 years? Assume the first payment is made one year from today and the interest rate is 11.00%.
In: Accounting
#38
|
Category |
Prior year |
Current year |
|
Accounts payable |
41,400 |
45,000 |
|
Accounts receivable |
115,200 |
122,400 |
|
Accruals |
16,200 |
13,500 |
|
Additional paid in capital |
200,000 |
216,660 |
|
Cash |
??? |
??? |
|
Common Stock @ par value |
37,600 |
42,000 |
|
COGS |
131,400 |
175,647.00 |
|
Depreciation expense |
21,600 |
23,080.00 |
|
Interest expense |
16,200 |
16,385.00 |
|
Inventories |
111,600 |
115,200 |
|
Long-term debt |
135,000 |
139,379.00 |
|
Net fixed assets |
376,827.00 |
399,600 |
|
Notes payable |
59,400 |
64,800 |
|
Operating expenses (excl. depr.) |
50,400 |
68,874.00 |
|
Retained earnings |
122,400 |
136,800 |
|
Sales |
255,600 |
337,253.00 |
|
Taxes |
9,900 |
19,019.00 |
What is the current year's return on assets (ROA)?
In: Finance
Below is selected information from Tricrop:
| Year 1 | Year 2 | |
| Net operating assets/common stock | 1.37 | 1.53 |
| Net operating profit margin | 19% | 21% |
| Income tax rate | 47% | 28% |
| Revenues/average net operating assets | 0.81 | 0.61 |
| EBIT/revenues | 38% | 32% |
Which of the following is correct concerning changes at Tricrop from Year 1 to Year 2?
| RNOA | ROCE | |
| Option A | Increased | Increased |
| Option B | Increased | Decreased |
| Option C | Decreased | Decreased |
| Option D | Decreased | Increased |
Group of answer choices
Option A
Option D
Option C
Option B
In: Finance
| Category | Prior Year | Current Year |
| Accounts payable | 3,148.00 | 5,978.00 |
| Accounts receivable | 6,987.00 | 9,075.00 |
| Accruals | 5,679.00 | 6,062.00 |
| Additional paid in capital | 19,911.00 | 13,723.00 |
| Cash | ??? | ??? |
| Common Stock | 2,850 | 2,850 |
| COGS | 22,424.00 | 18,276.00 |
| Current portion long-term debt | 500 | 500 |
| Depreciation expense | 983.00 | 959.00 |
| Interest expense | 1,262.00 | 1,152.00 |
| Inventories | 3,018.00 | 6,677.00 |
| Long-term debt | 17,000.00 | 22,791.00 |
| Net fixed assets | 75,310.00 | 74,221.00 |
| Notes payable | 4,066.00 | 6,554.00 |
| Operating expenses (excl. depr.) | 19,950 | 20,000 |
| Retained earnings | 35,527.00 | 34,370.00 |
| Sales | 46,360 | 45,467.00 |
| Taxes | 350 | 920 |
What is the firm's cash flow from financing?
Submit
Answer format: Number: Round to: 0 decimal places.
| Category | Prior Year | Current Year |
| Accounts payable | 3,148.00 | 5,978.00 |
| Accounts receivable | 6,987.00 | 9,075.00 |
| Accruals | 5,679.00 | 6,062.00 |
| Additional paid in capital | 19,911.00 | 13,723.00 |
| Cash | ??? | ??? |
| Common Stock | 2,850 | 2,850 |
| COGS | 22,424.00 | 18,276.00 |
| Current portion long-term debt | 500 | 500 |
| Depreciation expense | 983.00 | 959.00 |
| Interest expense | 1,262.00 | 1,152.00 |
| Inventories | 3,018.00 | 6,677.00 |
| Long-term debt | 17,000.00 | 22,791.00 |
| Net fixed assets | 75,310.00 | 74,221.00 |
| Notes payable | 4,066.00 | 6,554.00 |
| Operating expenses (excl. depr.) | 19,950 | 20,000 |
| Retained earnings | 35,527.00 | 34,370.00 |
| Sales | 46,360 | 45,467.00 |
| Taxes | 350 | 920 |
What is the firm's total change in cash from the prior year to the current year?
In: Accounting
|
Category |
Prior year |
Current year |
|
Accounts payable |
41,400 |
45,000 |
|
Accounts receivable |
115,200 |
122,400 |
|
Accruals |
16,200 |
13,500 |
|
Additional paid in capital |
200,000 |
216,660 |
|
Cash |
??? |
??? |
|
Common Stock @ par value |
37,600 |
42,000 |
|
COGS |
131,400 |
170,550.00 |
|
Depreciation expense |
21,600 |
22,669.00 |
|
Interest expense |
16,200 |
16,971.00 |
|
Inventories |
111,600 |
115,200 |
|
Long-term debt |
135,000 |
139,896.00 |
|
Net fixed assets |
379,919.00 |
399,600 |
|
Notes payable |
59,400 |
64,800 |
|
Operating expenses (excl. depr.) |
50,400 |
64,100.00 |
|
Retained earnings |
122,400 |
136,800 |
|
Sales |
255,600 |
338,777.00 |
|
Taxes |
9,900 |
19,248.00 |
What is the current year's return on assets (ROA)?
In: Finance
|
Property type |
Price |
Mortgage |
Expected |
Estimated |
|
|---|---|---|---|---|---|
|
Rental income |
Depreciation expense |
resale |
|||
|
(per year) |
(per year) |
value |
|||
| Strip shopping center | $800,000 | $448,000 | $136,016 | $7,692 | $912,000 |
| Small apartment complex | $650,000 | $292,500 | $91,281 | $8,273 | $685,100 |
The first potential investment consists of a seven-store shopping center, which has a current market price of $800,000. Of this amount, $200,000 represents the cost of the land, and the balance, $600,000, is attributable to buildings on the property. The second possible investment, which costs $650,000, consists of a small four-unit apartment complex. $195,000 of the investment's total price is reflects the cost of land, and the remaining $455,000 is associated with structures on the land. For both properties, you believe you can increase the rents 2% per year for each of the next four years, and expect to sell either property at the end that time. You desire a return of 7% on your investments.
Assume that your expected annual operating costs—excluding your annual depreciation expense—for the commercial property will be 35% of your annual rental income. For the residential property, the annual operating costs (excluding depreciation expense) will be 20% of your annual rental income. The interest rates of the mortgages for the commercial and residential lease properties are expected to be 6% and 4%, respectively.
Given your other assumptions, complete the following two tables and then use your computations to answer several questions. Round all amounts to the nearest whole dollar. (Hint: Don’t round intermediate calculations. Also, don’t forget that capital gains are taxed at 15% if properties are sold for more than their original purchase price.)
|
Strip shopping center |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
|---|---|---|---|---|
| Annual rental income | ||||
| Estimated resale value | 0 | 0 | 0 | |
| Less: Annual operating expenses | ||||
| Less: Annual depreciation expense | ||||
| Less: Annual interest payments (6%) | 26,880 | 25,536 | 24,192 | 22,848 |
| Less: Taxes (25%) | ||||
| Less: Capital gains tax (15%) | 0 | 0 | 0 | |
| Net profit | ||||
| Interest factor (7%) | 0.9346 | 0.8734 | 0.8163 | 0.7629 |
| PV of Cash flow | ||||
| Total PV of Cash flows |
The net discounted return expected from an investment in the shopping center—after deducting the cost of the investment—is ( $30,991, $830,991, $55784, $24,793) .
In: Finance
| Item | Prior year | Current year |
| Accounts payable | 8,102.00 | 7,809.00 |
| Accounts receivable | 6,028.00 | 6,680.00 |
| Accruals | 983.00 | 1,392.00 |
| Cash | ??? | ??? |
| Common Stock | 11,946.00 | 12,572.00 |
| COGS | 12,688.00 | 18,343.00 |
| Current portion long-term debt | 4,928.00 | 5,020.00 |
| Depreciation expense | 2,500 | 2,820.00 |
| Interest expense | 733 | 417 |
| Inventories | 4,260.00 | 4,775.00 |
| Long-term debt | 13,063.00 | 14,127.00 |
| Net fixed assets | 50,599.00 | 54,949.00 |
| Notes payable | 4,309.00 | 9,861.00 |
| Operating expenses (excl. depr.) | 13,977 | 18,172 |
| Retained earnings | 28,053.00 | 30,112.00 |
| Sales | 35,119 | 46,621.00 |
| Taxes | 2,084 | 2,775 |
What is the firm's cash flow from financing?
In: Finance
| Item | Prior year | Current year |
| Accounts payable | 8,159.00 | 7,896.00 |
| Accounts receivable | 6,010.00 | 6,644.00 |
| Accruals | 957.00 | 1,541.00 |
| Cash | ??? | ??? |
| Common Stock | 10,381.00 | 12,875.00 |
| COGS | 12,661.00 | 18,004.00 |
| Current portion long-term debt | 5,054.00 | 5,069.00 |
| Depreciation expense | 2,500 | 2,844.00 |
| Interest expense | 733 | 417 |
| Inventories | 4,158.00 | 4,797.00 |
| Long-term debt | 14,968.00 | 13,143.00 |
| Net fixed assets | 50,662.00 | 54,550.00 |
| Notes payable | 4,383.00 | 9,863.00 |
| Operating expenses (excl. depr.) | 13,977 | 18,172 |
| Retained earnings | 28,503.00 | 29,396.00 |
| Sales | 35,119 | 45,618.00 |
| Taxes | 2,084 | 2,775 |
What is the firm's total change in cash from the prior year to the current year?
In: Finance
| Chapter 8: Applying Excel | |||||||
| Data | Year 2 Quarter | Year 3 Quarter | |||||
| 1 | 2 | 3 | 4 | 1 | 2 | ||
| Budgeted unit sales | 40,000 | 60,000 | 100,000 | 50,000 | 70,000 | 80,000 | |
| • Selling price per unit | $8 | per unit | |||||
| • Accounts receivable, beginning balance | $65,000 | ||||||
| • Sales collected in the quarter sales are made | 75% | ||||||
| • Sales collected in the quarter after sales are made | 25% | ||||||
| • Desired ending finished goods inventory is | 30% | of the budgeted unit sales of the next quarter | |||||
| • Finished goods inventory, beginning | 12,000 | units | |||||
| • Raw materials required to produce one unit | 5 | pounds | |||||
| • Desired ending inventory of raw materials is | 10% | of the next quarter's production needs | |||||
| • Raw materials inventory, beginning | 23,000 | pounds | |||||
| • Raw material costs | $0.80 | per pound | |||||
| • Raw materials purchases are paid | 60% | in the quarter the purchases are made | |||||
| and | 40% | in the quarter following purchase | |||||
| • Accounts payable for raw materials, beginning balance | $81,500 | ||||||
| Enter a formula into each of the cells marked with a ? below | |||||||
| Review Problem: Budget Schedules | |||||||
| Construct the sales budget | Year 2 Quarter | Year 3 Quarter | |||||
| 1 | 2 | 3 | 4 | 1 | 2 | ||
| Budgeted unit sales | ? | ? | ? | ? | ? | ? | |
| Selling price per unit | ? | ? | ? | ? | ? | ? | |
| Total sales | ? | ? | ? | ? | ? | ? | |
| Construct the schedule of expected cash collections | Year 2 Quarter | ||||||
| 1 | 2 | 3 | 4 | Year | |||
| Accounts receivable, beginning balance | ? | ? | |||||
| First-quarter sales | ? | ? | ? | ||||
| Second-quarter sales | ? | ? | ? | ||||
| Third-quarter sales | ? | ? | ? | ||||
| Fourth-quarter sales | ? | ? | |||||
| Total cash collections | ? | ? | ? | ? | ? | ||
| Construct the production budget | Year 2 Quarter | Year 3 Quarter | |||||
| 1 | 2 | 3 | 4 | Year | 1 | 2 | |
| Budgeted unit sales | ? | ? | ? | ? | ? | ? | ? |
| Add desired finished goods inventory | ? | ? | ? | ? | ? | ? | |
| Total needs | ? | ? | ? | ? | ? | ? | |
| Less beginning inventory | ? | ? | ? | ? | ? | ? | |
| Required production | ? | ? | ? | ? | ? | ? | |
| Construct the raw materials purchases budget | Year 2 Quarter | Year 3 Quarter | |||||
| 1 | 2 | 3 | 4 | Year | 1 | ||
| Required production (units) | ? | ? | ? | ? | ? | ? | |
| Raw materials required to produce one unit | ? | ? | ? | ? | ? | ? | |
| Production needs (pounds) | ? | ? | ? | ? | ? | ? | |
| Add desired ending inventory of raw materials (pounds) | ? | ? | ? | ? | ? | ||
| Total needs (pounds) | ? | ? | ? | ? | ? | ||
| Less beginning inventory of raw materials (pounds) | ? | ? | ? | ? | ? | ||
| Raw materials to be purchased | ? | ? | ? | ? | ? | ||
| Cost of raw materials per pound | ? | ? | ? | ? | ? | ||
| Cost of raw materials to be purchased | ? | ? | ? | ? | ? | ||
| Construct the schedule of expected cash payments | Year 2 Quarter | ||||||
| 1 | 2 | 3 | 4 | Year | |||
| Accounts payable, beginning balance | ? | ? | |||||
| First-quarter purchases | ? | ? | ? | ||||
| Second-quarter purchases | ? | ? | ? | ||||
| Third-quarter purchases | ? | ? | ? | ||||
| Fourth-quarter purchases | ? | ? | |||||
| Total cash disbursements | ? | ? | ? | ? | ? | ||
In: Accounting