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 | |||||||||
ekkarill92 answered 1 year agoRelated 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
Latest Questions
- The following are the monthly rates of return for Madison Cookies and for Sophie Electric during...
- 1.) Think back to August 6, 1945. The United States has just dropped an atomic weapon...
- Carry out the equipment and operating procedures between injection molding of thermoplastics and injection molding of...
- The cumulative timing approach was used to time a job and its elements. Use the following...
- absorption refection scattering refraction and diffraction can all have an impact on RF signal strength. Identify...
- This is my code I need to complete it? //The code package arraylists; import java.util.ArrayList; import...
- Organization management function at Tesla, and how can they improve the structure
ADVERTISEMENT