The Freeman Manufacturing Company is considering a new
investment. Financial projections for the investment are tabulated
below. The corporate tax rate is 34 percent. Assume all sales
revenue is received in cash, all operating costs and income taxes
are paid in cash, and all cash flows occur at the end of the year.
All net working capital is recovered at the end of the
project.
| Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | ||||||
| Investment | $ | 41,000 | ||||||||
| Sales revenue | $ | 21,000 | $ | 21,500 | $ | 22,000 | $ | 19,000 | ||
| Operating costs | 4,400 | 4,500 | 4,600 | 3,800 | ||||||
| Depreciation | 10,250 | 10,250 | 10,250 | 10,250 | ||||||
| Net working capital spending | 470 | 520 | 570 | 470 | ? | |||||
a. Compute the incremental net income of the
investment for each year. (Do not round intermediate
calculations.)
| Year 1 | Year 2 | Year 3 | Year 4 | ||
| Net income | $ | $ | $ | $ | |
b. Compute the incremental cash flows of the
investment for each year. (Do not round intermediate
calculations. A negative answer
should be indicated by a minus sign.)
| Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | |
| Cash flow | $ | $ | $ | $ | $ |
c. Suppose the appropriate discount rate is 13
percent. What is the NPV of the project? (Do not round
intermediate calculations and round your answer to 2 decimal
places, e.g., 32.16.)
NPV $
In: Finance
Exercise 9-14 Prepare a Flexible Budget Performance Report [LO9-4]
Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides data concerning the company’s costs:
| Fixed Cost per Month |
Cost per Car Washed |
||||||
| Cleaning supplies | $ | 0.80 | |||||
| Electricity | $ | 1,200 | $ | 0.09 | |||
| Maintenance | $ | 0.15 | |||||
| Wages and salaries | $ | 4,500 | $ | 0.40 | |||
| Depreciation | $ | 8,200 | |||||
| Rent | $ | 1,800 | |||||
| Administrative expenses | $ | 1,600 | $ | 0.02 | |||
For example, electricity costs are $1,200 per month plus $0.09 per car washed. The company expects to wash 8,400 cars in August and to collect an average of $6.30 per car washed.
The actual operating results for August appear below.
| Lavage Rapide | ||
| Income Statement | ||
| For the Month Ended August 31 | ||
| Actual cars washed | 8,500 | |
| Revenue | $ | 55,020 |
| Expenses: | ||
| Cleaning supplies | 7,220 | |
| Electricity | 1,926 | |
| Maintenance | 1,500 | |
| Wages and salaries | 8,220 | |
| Depreciation | 8,200 | |
| Rent | 2,000 | |
| Administrative expenses | 1,668 | |
| Total expense | 30,734 | |
| Net operating income | $ | 24,286 |
Required:
Prepare a flexible budget performance report that shows the company’s revenue and spending variances and activity variances for August. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
In: Accounting
Problem 8-2 Calculating Project NPV
The Freeman Manufacturing Company is considering a new
investment. Financial projections for the investment are tabulated
below. The corporate tax rate is 35 percent. Assume all sales
revenue is received in cash, all operating costs and income taxes
are paid in cash, and all cash flows occur at the end of the year.
All net working capital is recovered at the end of the
project.
| Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | ||||||
| Investment | $ | 32,000 | ||||||||
| Sales revenue | $ | 16,500 | $ | 17,000 | $ | 17,500 | $ | 14,500 | ||
| Operating costs | 3,500 | 3,600 | 3,700 | 2,900 | ||||||
| Depreciation | 8,000 | 8,000 | 8,000 | 8,000 | ||||||
| Net working capital spending | 380 | 430 | 480 | 380 | ? | |||||
a. Compute the incremental net income of the
investment for each year. (Do not round intermediate
calculations.)
| Year 1 | Year 2 | Year 3 | Year 4 | ||
| Net income | $ | $ | $ | $ | |
b. Compute the incremental cash flows of the
investment for each year. (Do not round intermediate
calculations. A negative answer
should be indicated by a minus sign.)
| Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | |
| Cash flow | $ | $ | $ | $ | $ |
c. Suppose the appropriate discount rate is 12
percent. What is the NPV of the project? (Do not round
intermediate calculations and round your answer to 2 decimal
places, e.g., 32.16.)
NPV $
In: Finance
Milano Pizza is a small neighborhood pizzeria that has a small area for in-store dining as well as offering take-out and free home delivery services. The pizzeria’s owner has determined that the shop has two major cost drivers—the number of pizzas sold and the number of deliveries made.
The pizzeria’s cost formulas appear below:
| Fixed Cost per Month |
Cost per Pizza |
Cost per Delivery |
||||||||
| Pizza ingredients | $ | 4.50 | ||||||||
| Kitchen staff | $ | 6,150 | ||||||||
| Utilities | $ | 730 | $ | 0.50 | ||||||
| Delivery person | $ | 3.30 | ||||||||
| Delivery vehicle | $ | 750 | $ | 1.50 | ||||||
| Equipment depreciation | $ | 496 | ||||||||
| Rent | $ | 2,110 | ||||||||
| Miscellaneous | $ | 850 | $ | 0.25 | ||||||
In November, the pizzeria budgeted for 1,920 pizzas at an average selling price of $19 per pizza and for 180 deliveries.
Data concerning the pizzeria’s actual results in November appear below:
| Actual Results | |||
| Pizzas | 2,020 | ||
| Deliveries | 160 | ||
| Revenue | $ | 39,050 | |
| Pizza ingredients | $ | 9,370 | |
| Kitchen staff | $ | 6,090 | |
| Utilities | $ | 945 | |
| Delivery person | $ | 528 | |
| Delivery vehicle | $ | 1,010 | |
| Equipment depreciation | $ | 496 | |
| Rent | $ | 2,110 | |
| Miscellaneous | $ | 862 | |
Required:
1. Complete the flexible budget performance report that shows both revenue and spending variances and activity variances for the pizzeria for November. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
In: Accounting
Bonobo’s Balloons Inc. purchased the $60,000 par value bonds of Gnomes R Us on January 1, 2020. The coupon rate is 8% and the bonds mature in 5 years. The market rate of interest is 12%. The bonds pay interest semi-annually every June 30 and December 31. The bonds were purchased for $51,167.90 and were classified as available-for-sale. Bonobo’s Balloons uses the effective-interest rate method to amortize bond discounts and premiums. At December 31, 2020, the market value of the bonds was $65,000. Bonobo’s Balloons sold the bonds on January 1, 2021, for $65,000.
Instructions
Computations:
Carrying value at December 31, 2020:
Interest revenue at June 30, 2020:
Unrealized gain/loss at December 31, 2020:
Gain or loss at January 1, 2021:
Requirement 5:
In: Accounting
Milano Pizza is a small neighborhood pizzeria that has a small area for in-store dining as well as offering take-out and free home delivery services. The pizzeria’s owner has determined that the shop has two major cost drivers—the number of pizzas sold and the number of deliveries made. The pizzeria’s cost formulas appear below: Fixed Cost per Month Cost per Pizza Cost per Delivery Pizza ingredients $ 4.50 Kitchen staff $ 5,930 Utilities $ 620 $ 0.40 Delivery person $ 3.20 Delivery vehicle $ 640 $ 1.60 Equipment depreciation $ 408 Rent $ 1,890 Miscellaneous $ 740 $ 0.20 In November, the pizzeria budgeted for 1,590 pizzas at an average selling price of $16 per pizza and for 230 deliveries. Data concerning the pizzeria’s actual results in November appear below: Actual Results Pizzas 1,690 Deliveries 210 Revenue $ 27,600 Pizza ingredients $ 7,390 Kitchen staff $ 5,870 Utilities $ 890 Delivery person $ 672 Delivery vehicle $ 988 Equipment depreciation $ 408 Rent $ 1,890 Miscellaneous $ 796 Required: 1. Complete the flexible budget performance report that shows both revenue and spending variances and activity variances for the pizzeria for November. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
In: Accounting
Milano Pizza is a small neighborhood pizzeria that has a small area for in-store dining as well as offering take-out and free home delivery services. The pizzeria’s owner has determined that the shop has two major cost drivers—the number of pizzas sold and the number of deliveries made.
The pizzeria’s cost formulas appear below:
| Fixed Cost per Month |
Cost per Pizza |
Cost per Delivery |
||||||||
| Pizza ingredients | $ | 4.80 | ||||||||
| Kitchen staff | $ | 5,990 | ||||||||
| Utilities | $ | 650 | $ | 0.70 | ||||||
| Delivery person | $ | 3.50 | ||||||||
| Delivery vehicle | $ | 670 | $ | 1.90 | ||||||
| Equipment depreciation | $ | 432 | ||||||||
| Rent | $ | 1,950 | ||||||||
| Miscellaneous | $ | 770 | $ | 0.10 | ||||||
In November, the pizzeria budgeted for 1,680 pizzas at an average selling price of $19 per pizza and for 180 deliveries.
Data concerning the pizzeria’s actual results in November appear below:
| Actual Results | |||
| Pizzas | 1,780 | ||
| Deliveries | 160 | ||
| Revenue | $ | 34,410 | |
| Pizza ingredients | $ | 7,930 | |
| Kitchen staff | $ | 5,930 | |
| Utilities | $ | 905 | |
| Delivery person | $ | 560 | |
| Delivery vehicle | $ | 994 | |
| Equipment depreciation | $ | 432 | |
| Rent | $ | 1,950 | |
| Miscellaneous | $ | 814 | |
Required:
1. Complete the flexible budget performance report that shows both revenue and spending variances and activity variances for the pizzeria for November. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
In: Accounting
BRAND purchased equipment for $290,000 cash, sold equipment costing $150,000 with a book value of $100,000, and declared and paid dividends during 2021. No new notes payable were issued during the year.
Financial data follows. All balances are normal.
| Balance Sheet |
Dec. 31, 2021 |
Dec. 31, 2020 |
Change |
|
Cash |
$ 36,000 |
$29,000 |
$ 7,000 |
|
Accounts receivable |
125,000 |
97,000 |
28,000 |
|
Inventory |
100,000 |
114,000 |
(14,000) |
|
Equipment |
740,000 |
600,000 |
140,000 |
|
Accum. depreciation |
370,000 |
220,000 |
150,000 |
|
Accounts payable |
170,000 |
150,000 |
20,000 |
|
Unearned revenue |
74,000 |
44,000 |
30,000 |
|
Accrued salaries |
25,000 |
40,000 |
(15,000) |
|
Taxes payable |
9,000 |
8,000 |
1,000 |
|
Long-term notes payable |
50,000 |
138,000 |
(88,000) |
|
Common stock |
215,000 |
200,000 |
15,000 |
|
Retained earnings |
88,000 |
40,000 |
48,000 |
| Income Statement |
2021 |
|
|
Sales revenue |
$2,800,000 |
|
|
Cost of sales |
1,600,000 |
|
|
Salaries expense |
900,000 |
|
|
Depreciation expense |
200,000 |
|
|
Interest expense |
20,000 |
|
|
Gain on sale of equipment |
10,000 |
|
|
Income tax expense |
25,000 |
|
|
Net income |
$ 65,000 |
|
Prepare BRANDS Statement of Cash Flows for 2021, using the indirect method.
Cash Flows from Operating Activities (CFO) =
Cash Flows from Investing Activities (CFI) =
Cash Flows from Financing Activities (CFF) =
Net increase/decrease in Cash =
When entering answers, enter them as whole numbers
In: Accounting
BRAND purchased equipment for $290,000 cash, sold equipment costing $150,000 with a book value of $100,000, and declared and paid dividends during 2021. No new notes payable were issued during the year.
Financial data follows. All balances are normal.
| Balance Sheet |
Dec. 31, 2021 |
Dec. 31, 2020 |
Change |
|
Cash |
$ 36,000 |
$29,000 |
$ 7,000 |
|
Accounts receivable |
125,000 |
97,000 |
28,000 |
|
Inventory |
100,000 |
114,000 |
(14,000) |
|
Equipment |
740,000 |
600,000 |
140,000 |
|
Accum. depreciation |
370,000 |
220,000 |
150,000 |
|
Accounts payable |
170,000 |
150,000 |
20,000 |
|
Unearned revenue |
74,000 |
44,000 |
30,000 |
|
Accrued salaries |
25,000 |
40,000 |
(15,000) |
|
Taxes payable |
9,000 |
8,000 |
1,000 |
|
Long-term notes payable |
50,000 |
138,000 |
(88,000) |
|
Common stock |
215,000 |
200,000 |
15,000 |
|
Retained earnings |
88,000 |
40,000 |
48,000 |
| Income Statement |
2021 |
|
|
Sales revenue |
$2,800,000 |
|
|
Cost of sales |
1,600,000 |
|
|
Salaries expense |
900,000 |
|
|
Depreciation expense |
200,000 |
|
|
Interest expense |
20,000 |
|
|
Gain on sale of equipment |
10,000 |
|
|
Income tax expense |
25,000 |
|
|
Net income |
$ 65,000 |
|
Prepare BRANDS Statement of Cash Flows for 2021, using the indirect method.
Cash Flows from Operating Activities (CFO) =
Cash Flows from Investing Activities (CFI) =
Cash Flows from Financing Activities (CFF) =
Net increase/decrease in Cash =
When entering answers, enter them as whole numbers
In: Accounting
Odin Tools purchased land with commercial buildings suitable for manufacturing its primary product, automotive tools in 2005 for 5.5 million dollars. Subsequently, in 2015 Odin Tools’ shareholders entered into an agreement to exchange all of the outstanding stock to Victory tools in exchange for Victory Tools’ common stock. In financial accounting, this would result in Odin becoming one of Victory Tools’ subsidiaries. Prior to concluding the deal, Victory Tools notified Odin that they had learned through discovery that the title to the Odin Tools’ real property was encumbered by $1,000,0000 in “liens” filed by Ulysses Ray Stuck in the county courthouse. In 2016 and 2017 Odin Tools paid legal expenses of $56,000 and $120,000 respectively to successfully remove those “liens”. The trial court found that the liens filed by U.R. Stuck were fraudulent. Odin Tools deducted these legal costs when filing their tax returns for 2016 and 2017. The Internal Revenue Service denied the deductions, restated Odin’s taxable income, assessed additional income taxes, and included a charge for interest on the disputed tax bill. The stock acquisition of Odin Tools was completed in 2018 by Victory Tools. Odin Tools has paid the additional taxes and interest to “stop the clock” and is seeking your advice on a course of action to recover those disputed taxes and interest from the Internal Revenue Service.
In: Accounting