Question

In: Accounting

The projected annual sales of an LED keychain are projected to be 25,000 the first year...

The projected annual sales of an LED keychain are projected to be 25,000 the first year and increase by 10,000 per year until 55,000 are sold during the fourth year. Sales are then predicted to decrease by 5,000 per year in the fifth year and each year therafter until 25,000 are sold in the tenth year.

Proposal A is to purchase manufacturing equipment costing $100,000 with an estimated salvage value of $20,000 at the end of 10 years.

Proposal B is to purchase manufacturing equipment costing $245,000 with an estimated salvage value of $50,000 at the end of 10 years. The variable manufacturing cost per unit under proposal A is estimated to be $0.80, but only $0.25 under proposal B.

1. If the interest rate is 9% what is the Present Equilavent cost of each proposal for a 10-year production period?

2. Which proposal should be accepted for a 10-year production period?

Solutions

Expert Solution

1.

Proposal A:
Year 0 1 2 3 4 5 6 7 8 9 10
Initial cost -100000
Annual variable cost -20000 -28000 -36000 -44000 -40000 -36000 -32000 -28000 -24000 -20000
Salvage Value 20000
Net cash flow -100000 -20000 -28000 -36000 -44000 -40000 -36000 -32000 -28000 -24000 0
Rate of interest 9%
Discounting factor 1 0.917431 0.84168 0.772183 0.708425 0.649931 0.596267 0.547034 0.501866 0.460428 0.422411
Present Value -100000 -18348.6 -23567 -27798.6 -31170.7 -25997.3 -21465.6 -17505.1 -14052.3 -11050.3 0
Present Equivalent Cost -290955
Working:
Year 1 2 3 4 5 6 7 8 9 10
Unit sales 25000 35000 45000 55000 50000 45000 40000 35000 30000 25000
Variable cost per unit 0.80 0.80 0.80 0.80 0.80 0.80 0.80 0.80 0.80 0.80
Annual variable cost 20000 28000 36000 44000 40000 36000 32000 28000 24000 20000
Proposal B:
Year 0 1 2 3 4 5 6 7 8 9 10
Initial cost -245000
Annual variable cost -6250 -8750 -11250 -13750 -12500 -11250 -10000 -8750 -7500 -6250
Salvage Value 50000
Net cash flow -245000 -6250 -8750 -11250 -13750 -12500 -11250 -10000 -8750 -7500 43750
Rate of interest 9%
Discounting factor 1 0.917431 0.84168 0.772183 0.708425 0.649931 0.596267 0.547034 0.501866 0.460428 0.422411
Present Value -245000 -5733.94 -7364.7 -8687.06 -9740.85 -8124.14 -6708.01 -5470.34 -4391.33 -3453.21 18480.47
Present Equivalent Cost -286193
Working:
Year 1 2 3 4 5 6 7 8 9 10
Unit sales 25000 35000 45000 55000 50000 45000 40000 35000 30000 25000
Variable cost per unit 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25
Annual variable cost 6250 8750 11250 13750 12500 11250 10000 8750 7500 6250

2.

Since the Present Equivalent Cost of Proposal B is less than for Proposal A, Proposal shall be accepted.


Related Solutions

A new piece of equipment costs $25,000. The annual cost of using the equipment is projected...
A new piece of equipment costs $25,000. The annual cost of using the equipment is projected to be $1000. Annual maintenance costs are expected to be $400 the first year, increasing by $75/yr each year after that. The effective annual interest rate is 5%. Using correct equivalence notation, write out (but do not solve) the equation that would be used to find the equivalent annual cost of purchasing the equipment for its 20-year lifespan.
A proposed new project has projected sales of $189,000, costs of $91,000, and depreciation of $25,000....
A proposed new project has projected sales of $189,000, costs of $91,000, and depreciation of $25,000. The tax rate is 23 percent. Calculate operating cash flow using the four different approaches. (Do not round intermediate calculations.) EBIT+ DEPRICIATION-TAXES TOP-down TAX-shield bottom-up
The projected balance of inventories at the end of the first year of operations is?
A family friend, Mr. Burn Out availed of the early retirement scheme offered by his employer. He said that he was already tired of the same routine of spending eight full hours in an office doing the same thing for the last twenty years. Mr. Burn Out plans to get into the field of entrepreneurship. He would invest part of his retirement pay in a business that would deal with the sale of medical supplies to local clinics and hospitals....
1. For a new product, sales volume in the first year is estimated to be 50,000 units and is projected to grow at a rate of 7% per year.
  1. For a new product, sales volume in the first year is estimated to be 50,000 units and is projected to grow at a rate of 7% per year. The selling price is $100 and will increase by $10 each year. Per-unit variable costs are $22 and annual fixed costs are $1,000,000. Per-unit costs are expected to increase 4% per year. Fixed costs are expected to increase 10% per year. Develop a spreadsheet model to predict the net present...
The projected sales of Terus Maju Holdings for the first and second quarter of 2009 are...
The projected sales of Terus Maju Holdings for the first and second quarter of 2009 are as follows: Month                         Total sales (RM) January                                   2 500 000 February                                 2 600 000 March                                      2 650 000 April                                         3 630 000 May                                         3 850 000 June                                        3 780 000 July                                          3 900 000 i. The company makes 20% cash sale, 50% is collected in the month following sales, and 30% is collected in the second month...
The Frontline Corporation's projected sales for the first 8 months of 2019 are shown in the...
The Frontline Corporation's projected sales for the first 8 months of 2019 are shown in the table below. Jan $        190,000 May $    300,000 Feb            120,000 Jun        270,000 Mar            135,000 Jul        225,000 Apr            240,000 Aug        150,000 Of Frontline's sales, 10% is for cash, 60% is collected in the month following the sales, and 30% is collected in the second month following sales. November and December 2018 sales were $220,000 and $175,000, respectively. Frontline purchases...
The projected balance of accounts payable at the end of the first year of operation is?
A family friend, Mr. Burn Out availed of the early retirement scheme offered by his employer. He said that he was already tired of the same routine of spending eight full hours in an office doing the same thing for the last twenty years. Mr. Burn Out plans to get into the field of entrepreneurship. He would invest part of his retirement pay in a business that would deal with the sale of medical supplies to local clinics and hospitals....
The projected balance of accounts receivable at the end of the first year of operations is?
A family friend, Mr. Burn Out availed of the early retirement scheme offered by his employer. He said that he was already tired of the same routine of spending eight full hours in an office doing the same thing for the last twenty years. Mr. Burn Out plans to get into the field of entrepreneurship. He would invest part of his retirement pay in a business that would deal with the sale of medical supplies to local clinics and hospitals....
What is the projected cash balance at the end of the first year of operations?
A family friend, Mr. Burn Out availed of the early retirement scheme offered by his employer. He said that he was already tired of the same routine of spending eight full hours in an office doing the same thing for the last twenty years. Mr. Burn Out plans to get into the field of entrepreneurship. He would invest part of his retirement pay in a business that would deal with the sale of medical supplies to local clinics and hospitals....
As of the end of the first year of operations, the projected total current assets is?
A family friend, Mr. Burn Out availed of the early retirement scheme offered by his employer. He said that he was already tired of the same routine of spending eight full hours in an office doing the same thing for the last twenty years. Mr. Burn Out plans to get into the field of entrepreneurship. He would invest part of his retirement pay in a business that would deal with the sale of medical supplies to local clinics and hospitals....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT