Question

In: Accounting

The estimated project cost, sales, rent, selling price and production and selling costs of the product...

The estimated project cost, sales, rent, selling price and production and selling costs of the product of a new project are given below. Compute the NPV and payback period of the project. Assume the costs are incurred at the beginning of the year, zero depreciation, no taxes, and discount rate as 10%, Show all calculations.

Year 1 Year 2 Year 3 Year 4 Year 5 Year 6
Project cost (Rs. Million) 40 70
Rent for land, buildings and machinery (Rs. Million) 3 40 5 5 6 6
Sales (Million Units) 2 2 3 3 4
Selling Price (Rs./Unit) 35 35 40 40 45
Production and Selling Costs (Rs. Million) 18 20 22 22 30

Solutions

Expert Solution

Computation of NPV and Payback period
Sl. No Particulars Source Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Total
A Discount factor at 10% See Formula given 1 0.9091 0.8264 0.7513 0.683 0.6209 NA
B Project Cost (in Million) Given in question ₹ 40.00 ₹ 70.00 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 110.00
C Discounted project cost B * A ₹ 40.00 ₹ 63.64 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 103.64
D Rent for land, building and machinery Given in question ₹ 3.00 ₹ 40.00 ₹ 5.00 ₹ 5.00 ₹ 6.00 ₹ 6.00 ₹ 65.00
E Discounted cost of (D) D * A ₹ 3.00 ₹ 36.36 ₹ 4.13 ₹ 3.76 ₹ 4.10 ₹ 3.73 ₹ 55.08
F Total Cash outflow E + C ₹ 43.00 ₹ 100.00 ₹ 4.13 ₹ 3.76 ₹ 4.10 ₹ 3.73 ₹ 158.71
G Sales Units (in Million) Given in question ₹ 0.00 ₹ 2.00 ₹ 2.00 ₹ 3.00 ₹ 3.00 ₹ 4.00 ₹ 14.00
H Selling price per unit Given in question ₹ 0.00 ₹ 35.00 ₹ 35.00 ₹ 40.00 ₹ 40.00 ₹ 45.00 ₹ 195.00
I Production and Selling cost (In million) Given in question ₹ 0.00 ₹ 18.00 ₹ 20.00 ₹ 22.00 ₹ 22.00 ₹ 30.00 ₹ 112.00
J Operational Profit (G*H) - I ₹ 0.00 ₹ 52.00 ₹ 50.00 ₹ 98.00 ₹ 98.00 ₹ 150.00 ₹ 448.00
K Discounted Cash inflow J * A ₹ 0.00 ₹ 47.27 ₹ 41.32 ₹ 73.63 ₹ 66.93 ₹ 93.14 ₹ 322.29
I Net present Value Total (K) - Total (F) -₹ 43.00 -₹ 52.73 ₹ 37.19 ₹ 69.87 ₹ 62.84 ₹ 89.41 ₹ 163.58
Payback period = The period required to recover the project cost
Payback period (Normal) Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Total
Project cost ₹ 40.00 ₹ 70.00 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 110.00
Cashflow in each year -₹ 40.00 ₹ 52.00 ₹ 50.00 ₹ 98.00 ₹ 98.00 ₹ 150.00 ₹ 448.00
Cumulative cashflow -₹ 40.00 ₹ 12.00 ₹ 62.00 ₹ 160.00 ₹ 258.00 ₹ 408.00 ₹ 856.00
Therefore payback period = (Total Project cost - 3rd year cashflow)/((4th year's cumulative cashflow - 3rd year cumulative cashflow)/12 months)
Plus
3 years
= (110-62)/(160-62)/12 = 5.88 months Plus 3 years
Therefore, Payback period = 3 years and 5.88 months (approx)
Note: Formula for Discount factor = 1 / (1 x (1 + Discount Rate) ^ Period Number)
Since question does not mention about if it discounted or normal pay back period, normal pay back period is computed

Related Solutions

The details of estimated project cost, sales and selling price of the product, depreciation and salvage...
The details of estimated project cost, sales and selling price of the product, depreciation and salvage value of a new project are given in the table below. All revenues and costs occur at the end of the period. The income tax rate is 20%. a) Find NPV of the project if the discount rate is 10%. b) The promoters has invested Rs 55 million in Year 1 and Rs 35 million in Year 2. Prepare the cash flow statement (Sources...
Product Original Cost Replacement Cost Estimated Disposal Cost Expected Selling Price Normal Profit on Sales A...
Product Original Cost Replacement Cost Estimated Disposal Cost Expected Selling Price Normal Profit on Sales A $30.00 $28.00 $8.00 $44.00 25.00% B $44.00 $42.00 $10.00 $54.00 20.00% C $124.00 $119.00 $29.00 $210.00 30.00% D $18.00 $15.40 $6.00 $30.00 20.00% Using the lower-of-cost-or-market approach applied on an individual-item basis, compute the inventory valuation that should be reported for each product on December 31, 2017
TG manufactures Product Z. Its standard selling price is $55. The production and sales budget for...
TG manufactures Product Z. Its standard selling price is $55. The production and sales budget for the quarter ended 31 March 20X3 was 7,500 units. The standard specification per unit of Product Z comprises: Direct labour 4 standard hours at $6/hour Direct material 1.2 kg at $10/kg Standard variable overhead 4 standard hours at $1/hour Budgeted fixed overhead $75,000 At the end of the quarter the management accounts showed the following: Production and sales of product Z in units: 7700...
Break-Even Sales Currently, the unit selling price of a product is $380, the unit variable cost...
Break-Even Sales Currently, the unit selling price of a product is $380, the unit variable cost is $310, and the total fixed costs are $1,001,000. A proposal is being evaluated to increase the unit selling price to $420. a. Compute the current break-even sales (units). units b. Compute the anticipated break-even sales (units), assuming that the unit selling price is increased and all costs remain constant. units
Estimated sales 15,000 books Beginning inventory 0 books Average selling price $81 per book Variable production...
Estimated sales 15,000 books Beginning inventory 0 books Average selling price $81 per book Variable production costs $54 per book Fixed production costs $225,000 per semester The fixed cost allocation rate is based on expected sales and is therefore equal to $ 225,000/15,000 books​ =$ 15 per book. Managers who are paid a bonus that is a function of gross margin may be inspired to produce a product in excess of demand to maximize their own bonus. There are metrics...
Kanada Inc. currently produces a product with the following cost characteristics: Selling price $85 Variable costs...
Kanada Inc. currently produces a product with the following cost characteristics: Selling price $85 Variable costs – production 31 Variable costs – selling and administrative 10 Total fixed costs $957458 Plant capacity 40542 Current product/sales volume 36429 Kanada Inc. can purchase additional capacity at a cost of $31426 in increments of 2730 units. A customer approaches AB Inc. for a special one-time order to purchase 9573 units. 62% of current variable selling and administrative costs would be incurred with this...
Cost per unit : $3.63 replacement cost : $3.34 Estimated selling price: $4.80 Cost of completion...
Cost per unit : $3.63 replacement cost : $3.34 Estimated selling price: $4.80 Cost of completion and disposal: $1.94 Normal profit margin (%) of selling price: 18% Estimated Selling price - Costs of completion and disposal = NRV $4.80 - $1.94 = $3.86 Sale price of inventory x Profit Margin (%) $4.80 x 18% = 0.864 NRV - the Normal Profit Margin $3.86 - 0.864 = 1.996 Replacement cost = $3.34 Question: What would be the journal entry for December...
Historical cost Estimated selling price Cost of completion Cost of disposal Current replacement cost Normal profit...
Historical cost Estimated selling price Cost of completion Cost of disposal Current replacement cost Normal profit margin 1. $60 $70 -- $5 $55 $7 2. $50 $80 $20 $6 $53 $3 3. $45 $44 $3 $2 $40 $4 4. $29 $40 $4 $6 $28 $5 5. $100 $110 $15 $5 $82 $5 For each set of independent facts listed, determine the appropriate measure of a unit of inventory under U.S. GAAP and IFRS. Assume the LIFO method is used. 1....
Currently, the unit selling price of a product is $310, the unit variable cost is $250, and the total fixed costs are $918,000.
  Currently, the unit selling price of a product is $310, the unit variable cost is $250, and the total fixed costs are $918,000. A proposal is being evaluated to increase the unit selling price to $340. a. Compute the current break-even sales (units).units b. Compute the anticipated break-even sales (units), assuming that the unit selling price is increased and all costs remain constant.units Break-Even Sales and Sales to Realize Income from Operations For the current year ended October 31,...
Estimated Fixed Cost Estimated Variable Cost (per unit sold) 2 Production costs: 3 Direct materials —...
Estimated Fixed Cost Estimated Variable Cost (per unit sold) 2 Production costs: 3 Direct materials — $56.00 4 Direct labor — 34.00 5 Factory overhead $188,000.00 20.00 6 Selling expenses: 7 Sales salaries and commissions 102,000.00 6.00 8 Advertising 39,000.00 — 9 Travel 12,000.00 — 10 Miscellaneous selling expense 7,400.00 1.00 11 Administrative expenses: 12 Office and officers’ salaries 141,200.00 — 13 Supplies 8,000.00 2.00 14 Miscellaneous administrative expense 13,600.00 1.00 15 Total $511,200.00 $120.00 It is expected that 21,300...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT