Differential Analysis - Three Scenarios Assignment
xlsx
keyboard_arrow_up
School
Concordia University *
*We aren’t endorsed by this school
Course
230
Subject
Accounting
Date
Apr 3, 2024
Type
xlsx
Pages
3
Uploaded by dogsuga
Current
Dirt
Mountain
Racing
$ 300,000 $ 90,000 $ 150,000 $ 60,000 $ 120,000 $ 27,000 $ 60,000 $ 33,000 $ 180,000 $ 63,000 $ 90,000 $ 27,000 $ 30,000 $ 10,000 $ 14,000 $ 6,000 $ 23,000 $ 6,000 $ 9,000 $ 8,000 $ 35,000 $ 12,000 $ 13,000 $ 10,000 $ 60,000 $ 18,000 $ 30,000 $ 12,000 $ 148,000 $ 46,000 $ 66,000 $ 36,000 $ 32,000 $ 17,000 $ 24,000 $ (9,000)
*Allocated on the basis of sales dollars.
$ (115,000)
Better or worse off?
Worse
Current
Difference
$ 300,000 $ - $ (300,000)
$ 120,000 $ - $ 120,000 $ 180,000 $ - $ (180,000)
$ 30,000 $ - $ 30,000 $ 23,000 $ 23,000 $ - $ 35,000 $ - $ 35,000 $ 60,000 $ 60,000 $ - $ 148,000 $ 83,000 $ 65,000 $ 32,000 $ (83,000)
$ (115,000) $ (115,000)
*Allocated on the basis of sales dollars.
Alternative approach:
Lost Contribution Margin from Racing Bikes
$ (180,000)
Avoidable Costs (Saved Fixed Expenses)
Advertising
$ 30,000 Salaies product line
$ 35,000 Total Avoidable Costs
$ 65,000 Net Difference
$ (115,000)
Differential Analysis - Add or Drop a Segment
The Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a racing bike. Data on sales and expenses for the past quarter follow:
Sales
Variable manufacturing and selling expenses
Contribution margin
Fixed expenses:
Advertising, traceable
Depreciation of special equipment
Salaries of product-line managers
Allocated common fixed expenses*
Total fixed expenses
Net operating income (loss)
Management is concerned about the continued losses shown by the racing bikes and wants a recommendation as to whether or not the line should be discontinued. The special equipment used to produce racing bikes has no resale value and does not wear out.
What is the impact on net operating income by discontinuing racing bikes? By how much would the company be better/worse off? Complete the analysis below to determine your answer.
Total if Racing Dropped
Sales
Variable manufacturing and selling expenses
Contribution margin
Fixed expenses:
Advertising, traceable
Depreciation of special equipment
Salaries of product-line managers
Allocated common fixed expenses*
Total fixed expenses
Net operating income (loss)
Per Unit
15,000 units per year
Direct Materials
$ 14 $ 210,000 Direct Labor
$ 10 $ 150,000 Variable Manufacturing Overhead
$ 3 $ 45,000 $ 6 $ 90,000 Fixed Manufacturing Overhead (general)
$ 9 $ 135,000 Total cost
$ 42 $ 630,000 * 1/3 supervisory salary, 2/3 depreciation of special equipment
Total for 15,000 units
15000
MAKE
BUY
MAKE
BUY
Cost of purchasing
$ 35 $ 525,000 Direct materials
$ 14 $ 210,000 Direct labor
$ 10 $ 150,000 VMOH
$ 3 $ 45,000 FMOH, traceable
$ 6 $ 90,000 FMOT, common
$ 9 $ 135,000 Total Costs
$ 42 $ 35 $ 630,000 $ 525,000 Make
Buy
Cost of Product
$ 630,000 $ 525,000 Opportunity Cost (foregone segment margin)
$ 150,000 Total Cost
$ 780,000 $ 525,000 Difference in favor of buying:
$ 255,000 Differential Analysis - Make vs. Buy
Troy Engines manufactures a variety of engines for use in heavy equipment. The company has always produced all the necessary parts for its engines, including the carburetors. An outside supplier has offered to sell Troy a carburetor for a cost of $35 per unit. To evaluate this offer, Troy has gathered the following information regarding its own cost of producing the carburetors internally.
Fixed Manufacturing Overhead (traceable)
*
Assuming that the company has no alternative use for the facilities that are now being used to produce the carburetors, should the outside supplier's offer be accepted? Show all computations.
Per Unit
Differential Costs
Suppose that if the carburetors were purchased, Troy could use the freed capacity to launch a new product. The segment margin of the new product would be $150,000 per year. Should Troy accept the offer to buy the carburetors for $35 per unit? Show all computations. Should the outside offer be accepted, given that there are no alternative uses for the facilities?
$
75
55
30
$
160
Required:
Per Unit
Total for 50 Coins
50
Incremental revenue $ 179 $ 8,950 Incremental costs:
Variable costs:
Direct materials $ 75 $ 3,750 Direct labor $ 55 $ 2,750 $ 30 $ 1,500 Special material
$ 2 $ 100 Total variable cost $ 162 $ 8,100 Fixed costs:
Purchase of special tool $ 350 Total incremental cost $ 8,450 Incremental net operating income $ 500 Sure if they want an extra $500
Differential Analysis - Special Order
Patriots Manufacturing is considering a special order for 50 hand-made gold coins for a customer. The normal selling price of a gold coin is $199 and its unit product cost is $160 as shown below:
Direct materials
Direct labor
Manufacturing overhead
Unit product cost
Most of the manufacturing overhead is fixed and unaffected by variations in how many coins are produced in any given period. However, $5 of the overhead is variable with respect to the number of coins produced. The customer who is interested in the gold coins would like special engraving applied to the coins. This engraving would require additional materials costing $2 per coin and would also require acquisition of a special engraving tool costing $350 that would have no other use once the special order is completed. This order would have no effect on the company’s regular sales and the order could be fulfilled using the company’s existing capacity without affecting any other order.
What effect would accepting this order have on the company’s net operating income if a special selling price of $179 per coin is offered for this order?
Variable manufacturing overhead
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
An engineer invests $10,000 a year for 20 years into a fund. At the end of the 20 years, how much
money is in the fund if the interest rate was 4% ? simple interest
A. $220,000
. B. $300,000
●
C. $240,000
D. $270,000
arrow_forward
How do you calculate the NPV and IRR
Project 1
Year
Cashflows
Discount Rate
10%
0
$ (750,000.00)
1
$ 250,000.00
2
$ 300,000.00
3
$ 350,000.00
4
$ 200,000.00
5
$ 100,000.00
Project 2
Year
Cashflows
Discount Rate
10%
0
$ (1,000,000.00)
1
$ 200,000.00
2
$ 300,000.00
3
$ 400,000.00
4
$ 500,000.00
5
$ 700,000.00
arrow_forward
!
Required information
[The following information applies to the questions displayed below.]
On January 1, Park Corporation and Strand Corporation had condensed balance
sheets as follows:
Park
Strand
$ 31,300
$ 116,000
107,500
Current assets
Noncurrent assets
49,200
Total assets
$ 223,500
$ 80,500
$ 52,500
66,000
105,000
Current liabilities
$ 30,500
Long-term debt
Stockholders' equity
50,000
$ 80,500
Total liabilities and equities
$ 223,500
On January 2, Park borrowed $70,400 and used the proceeds to obtain 80 percent
of the outstanding common shares of Strand. The acquisition price was considered
proportionate to Strand's total fair value. The $70,400 debt is payable in 10 equal
annual principal payments, plus interest, beginning December 31. The excess fair
value of the investment over the underlying book value of the acquired net assets
is allocated to inventory (60 percent) and to goodwill (40 percent).
On a consolidated balance sheet as of January 2, what should be the amount for…
arrow_forward
All techniques with NPV profile Mutually exclusive projects Projects A and B, of equal risk, are alternatives for expanding Rosa Company's capacity. The firm's cost of capital is 15%. The cash flows for each project are
shown in the following table
a. Calculate each project's payback period.
b. Calculate the net present value (NPV) for each project.
c. Calculate the internal rate of return (IRR) for each project
d. Indicate which project you would recommend
years (Round to two decimal places.)
a. The payback period of project A is
The payback period of project B is
years (Round to two decimal places.)
b. The NPV of project A is $
The NPV of project B is $
c. The IRR of project A is
The IRR of project B is 15.24%
(Round to the nearest cent.)
(Round to the nearest cent.)
15.92%. (Round to two decimal places.)
(Round to two decimal places.)
پہلے
arrow_forward
Baltusrol Inc. has the following three investment opportunities.
A
P70,000
10,000
B
Initial investment
Initial working capital required
Cash inflows by year:
Year 1
P70,000
5,000
P70,000
8,000
P35,000
35,000
10,000
5,000
8,000
P83.000
P1,250
P35,000
10,000
45.000
20,000
2,000
P112.000
P10,000
P4,000
8,000
10,000
98,000
5.000
P125.000
P12,500
Year 2
Year 3
Year 4
Released working capital
Total
Average annual income
Required:
1. Rank the investment opportunities in order of desirability using.
A. Payback period.
B. Average book rate of return (use average net book value of the investment as the denominator), and
C. NPV using a 16% discount rate.
2. Determine the profitability index for each opportunity and rank the investments based on these values.
arrow_forward
The following information is provided by Doppler Systems:
Project A
Project B
Project C Project D
Initial investment
$440,000
$202,000
$550,000
$506,000
PV of cash inflows
$570,000
$394,000
$816,000
$406,000
Payback period (years)
3.6
3.2
4.0
20
NPV of project
$130,000
$192,000
$266,000
$100,000
Calculate the profitability index for Project A. (Round your answer to two decimal places.)
1.09
1.67
0.85
1.30
arrow_forward
Please help me
arrow_forward
You are given the following cash flow information for Project A
TV Inflows
Year
0
PV Outflows
-$150,000.00
1
Project A
-$150,000.00
$80,000.00
-$25,000.00
$50,000.00
2
$80,000.00
-$30,000.00
$75,000.00
Totals
3
4
5
6
O 19.33%
$75,000.00
Now assume that the project's cost of capital is 16.0 percent, but that its true reinvestment rate is
24.0 percent. Given this information, determine the project's modified internal rate of return
(MIRR).
Ⓒ 18.56%
5 pts
arrow_forward
e to search
☐
shaikh amir - Easy E...
Texas Department o
Inspectors Depart... A Does an MIS make i...
Question 10
What is the IRR of Project C if the outlay is $225,000 and the after-tax cash inflows for years one through four are: $45,000, $70,000, $80,000, and $105,000?
O 13.21%
O 12.90
11.00
O 11.80
O 13.53.
D
Question 11
What is the NPV of Project C?
$4,274.96
1,138.33
O3.891.33
2,884.34
O2.638.33
Question 12
Based on IRR. ABC should accept
all throe
only A and B
only A and C
only C
a
arrow_forward
An engineer invests $10,000 a year for 20 years into a fund. At the end of the 20 years, how much money is in the fund if the interest rate was 4%? simple interest
A. $220,000
B. $300,000
C. $240,000
D. $270,000
arrow_forward
Choosing between two projects with acceptable payback periods Shell Camping Gear, Inc., is considering two mutually exclusive projects. Each requires an initial investment of $180,000. John Shell, president of the
company, has set a maximum payback period of 4 years.
The cash inflows associated with each project are shown in the following table:
a. Determine the payback period of each project.
b. Which project is acceptable based on payback period?
C
a. The payback period of project A is
years. (Round to two decimal places.)
The payback period of project B is
years. (Round to two decimal places.)
b. Which project is acceptable based on payback period? (Select the best answer below.)
O Project B would be preferred over project A because the larger cash flows are in the early years of the project.
O Project A would be preferred over project B because the larger cash flows are in the later years of the project.
arrow_forward
All techniques, conflicting rankings Nicholson Roofing Materials, Inc., is considering two mutually exclusive
projects, that both cost $130,000. The company's board of directors has set a 4-year payback requirement the cost of
capital is 7%. The project cash flows are shown in the following table:
a. Calculate the payback period for each project. Rank the projects by payback period.
b. Calculate the NPV of each project. Rank the project by NPV.
c. Calculate the IRR of each project. Rank the project by IRR.
d. Make a recommendation.
a. The payback period of project A is 2.89 years. (Round to two decimal places.)
The payback period of project B is 1.64 years. (Round to two decimal places.)
According to the payback method, which project should the firm choose? (Select the best answer below.)
A. Project B
B. Project A
b. The NPV of project A is $. (Round to the nearest cent.)
arrow_forward
Internal rate of return and modified internal rate of return. Quark Industries has three potential projects, all with an initial cost of $2,100,000. Given the discount rate and the future cash flow of each project in the
following table, E, what are the IRRS and MIRRS of the three projects for Quark Industries?
arrow_forward
What’s the NPV of project A
arrow_forward
which has a better IRR
Project 1
Year
Cashflows
Discount Rate
10%
0
$ (750,000.00)
1
$ 250,000.00
2
$ 300,000.00
3
$ 350,000.00
4
$ 200,000.00
5
$ 100,000.00
Project 2
Year
Cashflows
Discount Rate
10%
0
$ (1,000,000.00)
1
$ 200,000.00
2
$ 300,000.00
3
$ 400,000.00
4
$ 500,000.00
5
$ 700,000.00
arrow_forward
Help
arrow_forward
i will 5 upvotes urgent
A firm wants to sponsor a new engineering lab at a local university. This requires $4.0M to construct the lab, $1.5M to equip it, and $750,000 every 6 years for new equipment. What is the required endowment if the university will earn 8% interest on the funds?
arrow_forward
Project X (Videotapes of the Weather Report) ($10,000 investment) Project Y (Slow-Motion Replays of Commercials) ($30,000 investment) Year Cash Flow Year Cash Flow 1 $5,000 1 $15,000 2 3,000 8,000 ........ 3 4,000 9,000 4 3,600 4 11,000 ..
Compute the payback period (PB), net present value (NPV), internal rate of return (IRR), profitability index (PI) and excess of IRR over k. Assume k at 10%. Decide on which Project will you choose and why?
arrow_forward
Answer full question please thanks
arrow_forward
Year Investment A 2016 $400.000 2017 $400.000 2018 $400.000 2019 $400.000 2020 $400.000
Investment B $100.000 $100.000 $100.000 $1.000.000 $1.000.000 calculate the Npv of both
project
arrow_forward
am. 118.
arrow_forward
Take Home Portion
Wishful Thinking (WT) School of Management is building a new facility on a piece of donated land. It received
a generous cash donation from a local business to support the project, and now needs to borrow additional
$10,000,000 to complete the project. Therefore WT School of Mgmt issued $10,000,000 of 6.00% 10-year
bonds. These bonds were issued on January 1, 20X1, and pay interest annually on each January 1. The bonds
yield 7.00%. WT School of Mgmt incurred $600,000 in bond issue costs related to the bond sale (round up the
calculation to the nearest dollar).
(a) Prepare the journal entry to record the issuance of the bonds and the related bond issue costs
incurred on January 1, 20X1
THE
(b) Prepare a bond amortization schedule up to and including January 1, 20X5, using the effective interest
method (
Date
Jan 1, X1
Interest
Paid
Interest
Expense
Disc/Prem
Amortization
Bond
Carrying
Value
Jan 1, X2
Jan 1, X3
Jan 1, X4
Jan 1, X5
2
(c) Assume that on July 1, 20X4, WT…
arrow_forward
hello teacher please solve questions
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Related Questions
- An engineer invests $10,000 a year for 20 years into a fund. At the end of the 20 years, how much money is in the fund if the interest rate was 4% ? simple interest A. $220,000 . B. $300,000 ● C. $240,000 D. $270,000arrow_forwardHow do you calculate the NPV and IRR Project 1 Year Cashflows Discount Rate 10% 0 $ (750,000.00) 1 $ 250,000.00 2 $ 300,000.00 3 $ 350,000.00 4 $ 200,000.00 5 $ 100,000.00 Project 2 Year Cashflows Discount Rate 10% 0 $ (1,000,000.00) 1 $ 200,000.00 2 $ 300,000.00 3 $ 400,000.00 4 $ 500,000.00 5 $ 700,000.00arrow_forward! Required information [The following information applies to the questions displayed below.] On January 1, Park Corporation and Strand Corporation had condensed balance sheets as follows: Park Strand $ 31,300 $ 116,000 107,500 Current assets Noncurrent assets 49,200 Total assets $ 223,500 $ 80,500 $ 52,500 66,000 105,000 Current liabilities $ 30,500 Long-term debt Stockholders' equity 50,000 $ 80,500 Total liabilities and equities $ 223,500 On January 2, Park borrowed $70,400 and used the proceeds to obtain 80 percent of the outstanding common shares of Strand. The acquisition price was considered proportionate to Strand's total fair value. The $70,400 debt is payable in 10 equal annual principal payments, plus interest, beginning December 31. The excess fair value of the investment over the underlying book value of the acquired net assets is allocated to inventory (60 percent) and to goodwill (40 percent). On a consolidated balance sheet as of January 2, what should be the amount for…arrow_forward
- All techniques with NPV profile Mutually exclusive projects Projects A and B, of equal risk, are alternatives for expanding Rosa Company's capacity. The firm's cost of capital is 15%. The cash flows for each project are shown in the following table a. Calculate each project's payback period. b. Calculate the net present value (NPV) for each project. c. Calculate the internal rate of return (IRR) for each project d. Indicate which project you would recommend years (Round to two decimal places.) a. The payback period of project A is The payback period of project B is years (Round to two decimal places.) b. The NPV of project A is $ The NPV of project B is $ c. The IRR of project A is The IRR of project B is 15.24% (Round to the nearest cent.) (Round to the nearest cent.) 15.92%. (Round to two decimal places.) (Round to two decimal places.) پہلےarrow_forwardBaltusrol Inc. has the following three investment opportunities. A P70,000 10,000 B Initial investment Initial working capital required Cash inflows by year: Year 1 P70,000 5,000 P70,000 8,000 P35,000 35,000 10,000 5,000 8,000 P83.000 P1,250 P35,000 10,000 45.000 20,000 2,000 P112.000 P10,000 P4,000 8,000 10,000 98,000 5.000 P125.000 P12,500 Year 2 Year 3 Year 4 Released working capital Total Average annual income Required: 1. Rank the investment opportunities in order of desirability using. A. Payback period. B. Average book rate of return (use average net book value of the investment as the denominator), and C. NPV using a 16% discount rate. 2. Determine the profitability index for each opportunity and rank the investments based on these values.arrow_forwardThe following information is provided by Doppler Systems: Project A Project B Project C Project D Initial investment $440,000 $202,000 $550,000 $506,000 PV of cash inflows $570,000 $394,000 $816,000 $406,000 Payback period (years) 3.6 3.2 4.0 20 NPV of project $130,000 $192,000 $266,000 $100,000 Calculate the profitability index for Project A. (Round your answer to two decimal places.) 1.09 1.67 0.85 1.30arrow_forward
- Please help mearrow_forwardYou are given the following cash flow information for Project A TV Inflows Year 0 PV Outflows -$150,000.00 1 Project A -$150,000.00 $80,000.00 -$25,000.00 $50,000.00 2 $80,000.00 -$30,000.00 $75,000.00 Totals 3 4 5 6 O 19.33% $75,000.00 Now assume that the project's cost of capital is 16.0 percent, but that its true reinvestment rate is 24.0 percent. Given this information, determine the project's modified internal rate of return (MIRR). Ⓒ 18.56% 5 ptsarrow_forwarde to search ☐ shaikh amir - Easy E... Texas Department o Inspectors Depart... A Does an MIS make i... Question 10 What is the IRR of Project C if the outlay is $225,000 and the after-tax cash inflows for years one through four are: $45,000, $70,000, $80,000, and $105,000? O 13.21% O 12.90 11.00 O 11.80 O 13.53. D Question 11 What is the NPV of Project C? $4,274.96 1,138.33 O3.891.33 2,884.34 O2.638.33 Question 12 Based on IRR. ABC should accept all throe only A and B only A and C only C aarrow_forward
- An engineer invests $10,000 a year for 20 years into a fund. At the end of the 20 years, how much money is in the fund if the interest rate was 4%? simple interest A. $220,000 B. $300,000 C. $240,000 D. $270,000arrow_forwardChoosing between two projects with acceptable payback periods Shell Camping Gear, Inc., is considering two mutually exclusive projects. Each requires an initial investment of $180,000. John Shell, president of the company, has set a maximum payback period of 4 years. The cash inflows associated with each project are shown in the following table: a. Determine the payback period of each project. b. Which project is acceptable based on payback period? C a. The payback period of project A is years. (Round to two decimal places.) The payback period of project B is years. (Round to two decimal places.) b. Which project is acceptable based on payback period? (Select the best answer below.) O Project B would be preferred over project A because the larger cash flows are in the early years of the project. O Project A would be preferred over project B because the larger cash flows are in the later years of the project.arrow_forwardAll techniques, conflicting rankings Nicholson Roofing Materials, Inc., is considering two mutually exclusive projects, that both cost $130,000. The company's board of directors has set a 4-year payback requirement the cost of capital is 7%. The project cash flows are shown in the following table: a. Calculate the payback period for each project. Rank the projects by payback period. b. Calculate the NPV of each project. Rank the project by NPV. c. Calculate the IRR of each project. Rank the project by IRR. d. Make a recommendation. a. The payback period of project A is 2.89 years. (Round to two decimal places.) The payback period of project B is 1.64 years. (Round to two decimal places.) According to the payback method, which project should the firm choose? (Select the best answer below.) A. Project B B. Project A b. The NPV of project A is $. (Round to the nearest cent.)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning