Rank the investment proposals

Assignment Help Finance Basics
Reference no: EM133113928

1. Finally, use NPV (Net Present Value) method to rank the investment proposals and select the most appropriate one to pursue. What is the most challenging aspect of the NPV method? (Please identify all the variables you use in your calculation when you use a calculator. Ignore all CCA effect on cash flow).

Investment proposal #1 - adding 5 trucks

 

Initial expenditure

Year 1

Year 2

Year 3

Year 4

Year 5

Net cost of trucks

$ 300,000

 

 

 

 

 

Additional Revenue

 

$ 44,000

$ 76,000

$ 112,000

 225,000

$168,000

Additional cost

 

(11,000)

(11,000)

(11,000)

(11,000)

(11,000)

Amortization

 

(45,000)

(66,000)

(63,000)

(63,000)

(63,000)

Net increase in income

 

 (12,000)

(1,000)

38,000

151,000

94,000

Less: Tax at 33%

 

0

0

(12,540)

(49,830)

(31,020)

Increase in after-tax income

 

(12,000)

(1,000)

25,460

101,170

62,980

Add back amortization

 

45,000

66,000

63,000

63,000

63,000

Net change in cash flow

$(300,000)

$33,000

$65,000

$88,460

$164,170

$125,980

The second proposal is to purchase a more advanced wood crafting machine. The projected revenues and costs and changes in net cash flow are summarized in the table below:

Investment proposal #2 - adding a wood crafting machine:

 

Initial expenditure

Year 1

Year 2

Year 3

Year 4

Year 5

Net cost of trucks

$ 700,000

 

 

 

 

 

Additional Revenue

 

$ 87,000

$ 175,000

$ 262,000

 393,000

$325,000

Additional cost

 

(26,000)

(26,000)

(26,000)

(26,000)

(26,000)

Amortization

 

(17,000)

(17,000)

(17,000)

(17,000)

(17,000)

Net increase in income

 

  44,000

132,000

219,000

350,000

282,000

Less: Tax at 33%

 

(14,520)

(43,560)

(72,270)

(115,500)

(93,060)

Increase in after-tax income

 

29,480

88,440

146,730

234,500

188,940

Add back amortization

 

17,000

17,000

17,000

17,000

17,000

Net change in cash flow

$(700,000)

$46,480

$105,440

$163,730

$251,500

$205,940

The third proposal is to add a new production line making new type of baby furniture. The projected increased revenues and costs and net changes in cash flows are summarized in the table below:

Investment proposal #3 - adding a new product line: 

 

Initial expenditure

Year 1

Year 2

Year 3

Year 4

Year 5

Net cost of trucks

$ 510,000

 

 

 

 

 

Additional Revenue

 

$ 381,000

$ 310,000

$ 87,000

 $70,000

$ 51,000

Additional cost

 

(19,000)

(19,000)

(25,000)

(31,000)

(38,000)

Amortization

 

(76,000)

(112,000)

(107,000)

(107,000)

(107,000)

Net increase in income

 

286,000

179,000

(45,000)

(68,000)

(94,000)

Less: Tax at 33%

 

(94,380)

(59,070)

0

0

0

Increase in after-tax income

 

191,620

119,930

(45,000)

(68,000)

(94,000)

Add back amortization

 

76,000

112,000

107,000

107,000

107,000

Net change in cash flow

$(510,000)

$267,620

$231,930

$62,000

$39,000

$13,000

Reference no: EM133113928

Questions Cloud

Find yield to? maturity-abner? corporation : Abner? Corporation's bonds mature in 21 years and pay 9 percent interest annually. If you purchase the bonds for $1,300, what is your yield to? maturity?
Discuss hiens cash position : Discuss Hien's cash position. Is there any other information which might be useful to you in order to give her good advice - Prepare the statement of financial
What is the most you should be willing to pay to repair : Your company's conveyor belt has broken and you have to decide whether to fix it or buy a new one. You ordinarily buy a new belt every ten years, and you have h
Prepare general journal entries to record the budget : In addition it recognizes that it must pay $10,000 legal suit, Prepare General Journal Entries to record the Budget for 2023
Rank the investment proposals : 1. Finally, use NPV (Net Present Value) method to rank the investment proposals and select the most appropriate one to pursue. What is the most challenging aspe
What is the inflation premium for an investment : What is the inflation premium for an investment when the real rate of return is 3 percent, the risk premium is 2 percent, and the required return is 9 percent?
What would be the value of all io strips : BOA originates 15 Fully Amortizing Fixed Rate non-recourse Mortgages, each has a $120 balance, 12% interest rate (no fees), 2-year term, and annual payments. BO
Thoughts on poverty and crime : Describe your thoughts on poverty and crime. Does and impoverished youth who has a two-parent household reframe your personal evaluation of this theory?
What would be the boa profits : Assume the expected prepayment rate in year 1 is 30%.

Reviews

Write a Review

Finance Basics Questions & Answers

  Assess loan options 50 36 calculate the ear for two banks

Assess Loan Options 50 36 Calculate the EAR for two banks

  Underlying asset price will increase in the future

"Speculators (who long futures) and Hedgers (who have a long hedge) share the same prediction that the underlying asset price will increase in the future."

  Wacc and corporate investment decisions

Students should understand corporate risk and be able to use the financial models learned in the class to evaluate and calculate a company

  Confidence interval and statistical tie

Explain the meaning of a candidate lead is outside the margin of error by 95% confidence interval and statistical tie.

  Describing what is likely to happen to interest rates

describing what is likely to happen to interest rates deposits and total bank reserves.1.what special status is awarded

  Revenues and other operating costs are expected to be

temple corp. is considering a new project whose data are shown below. the equipment that would be used has a 3-year

  What is the project mirr

What is the project's MIRR? Do not round intermediate calculations. Round your answer to two decimal places.

  Compute the operating breakeven point

Compute the degree of operating leverage (DOL) for each firm at their normal sales levels, and show that ODM is operating closer to the operating breakeven point than CWI.

  Prepare a balance sheet using the appropriate accounts

Wolfpack Construction has the following account balances at the end of the year.

  Describe an interest rate swap

Describe an interest rate swap and give an example based on the following information. A company with a comparative advantage in the fixed-rate market

  What is the amount of total liabilities

Its net working capital is $650. Its long-term debt is $4,000, What is the amount of total liabilities?

  Prepare a monthly cash budget for the last 6 months of 2014

Prepare an estimate of the required financing (or excess funds)-that is, the amount of money Rusty's Renovations will need to borrow (or will have available to invest)- for each month during that period.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd