Question
In: Finance
MLM Corporation, has provided you the following business operations data:
MLM Corporation, has provided you the following business operations data:
|
Items |
Value |
|
Equipment cost |
$8,750 |
|
Salvage value, equipment, Year 4 |
$750 |
|
Opportunity cost |
$0 |
|
Externalities (cannibalization) |
$0 |
|
Units sold, Year 1 |
12,000 |
|
Annual change in units sold, after Year 1 |
13% |
|
Sales price per unit, Year 1 |
$1.65 |
|
Annual change in sales price, after Year 1 |
3% |
|
Variable cost per unit (VC), Year 1 |
$1.07 |
|
Annual change in VC, after Year 1 |
3% |
|
Nonvariable cost (Non-VC), Year 1 |
$2,120 |
|
Annual change in Non-VC, after Year 1 |
2.5% |
|
Project cost of capital (r) |
12% |
|
Tax rate |
21% |
|
Working capital as % of next year's sales |
15% |
Moreover, they have tabulated cash flows and performance measures as shown below:
|
Years |
0 |
1 |
2 |
3 |
4 |
|
Unit sales |
12,000 |
13,560 |
15,323 |
17,315 |
|
|
Sales price per unit |
$1.65 |
$1.70 |
$1.75 |
$1.80 |
|
|
Variable cost per unit (excl. depr.) |
$1.07 |
$1.10 |
$1.12 |
$1.15 |
|
|
Nonvariable costs (excl. depr.) |
$2,120 |
$2,173 |
$2,227 |
$2,283 |
|
|
Sales revenues = Units × Price/unit |
$19,800 |
$23,045 |
$26,822 |
$31,219 |
|
|
NOWCt = 15%(Revenuest+1) |
$2,970 |
$3,457 |
$4,023 |
$4,683 |
$0 |
|
Basis for depreciation |
$8,750 |
||||
|
Annual depreciation rate (MACRS) |
33.33% |
44.45% |
14.81% |
7.41% |
|
|
Annual depreciation expense |
$2,916 |
$3,889 |
$1,296 |
$648 |
|
|
Remaining undepreciated value |
$5,834 |
$1,944 |
$648 |
$0 |
As a corporate finance advisor, you’re required to perform the following tasks: 1- Provide a cash flow forecast for the next four years.
2- Calculate NPV, IRR, MIRR, Profitability Index (PI), Payback, and Discounted Payback.
Solutions
Expert Solution
| 0 | 1 | 2 | 3 | 4 | ||
| Unit sales | 12000 | 13560 | 15323 | 17315 | ||
| Sales price per unit | $ 1.65 | $ 1.70 | $ 1.75 | $ 1.80 | ||
| Variable cost per unit [excl. depr] | $ 1.07 | $ 1.10 | $ 1.12 | $ 1.15 | ||
| Sales revenues | $ 19,800 | $ 23,045 | $ 26,822 | $ 31,219 | ||
| Variable costs | $ 12,840 | $ 14,916 | $ 17,162 | $ 19,912 | ||
| Non-variable costs [excl. depr] | $ 2,120 | $ 2,173 | $ 2,227 | $ 2,283 | ||
| Depreciation | $ 2,916 | $ 3,889 | $ 1,296 | $ 648 | ||
| NOI | $ 1,924 | $ 2,067 | $ 6,137 | $ 8,375 | ||
| Tax rate at 21% | $ 404 | $ 434 | $ 1,289 | $ 1,759 | ||
| NOPAT | $ 1,520 | $ 1,633 | $ 4,849 | $ 6,617 | ||
| Add: Depreciation | $ 2,916 | $ 3,889 | $ 1,296 | $ 648 | ||
| OCF | $ 4,436 | $ 5,522 | $ 6,144 | $ 7,265 | ||
| Capital expenditure | $ 8,500 | |||||
| Change in NWC | $ 2,970 | $ 487 | $ 567 | $ 660 | $ (4,683) | |
| After tax salvage value of equipment = 750*(1-21%) = | $ 593 | |||||
| FCF | $ (11,470) | $ 3,949 | $ 4,955 | $ 5,485 | $ 12,540 | |
| 1] | NPV: | |||||
| PVIF at 12% | 1 | 0.89286 | 0.79719 | 0.71178 | 0.63552 | |
| PV at 12% | $ (11,470) | $ 3,526 | $ 3,950 | $ 3,904 | $ 7,970 | |
| NPV | $ 7,880 | |||||
| 2] | IRR: | |||||
| IRR is that discount rate for which NPV = 0. It has to be arrived at by trial and error. | ||||||
| Discounting with 35%: | ||||||
| PVIF at 35% | 1 | 0.74074 | 0.54870 | 0.40644 | 0.30107 | |
| PV at 35% | $ (11,470) | $ 2,925 | $ 2,719 | $ 2,229 | $ 3,775 | |
| NPV | $ 179 | |||||
| Discounting with 36%: | ||||||
| PVIF at 36% | 1 | 0.73529 | 0.54066 | 0.39754 | 0.29231 | |
| PV at 36% | $ (11,470) | $ 2,904 | $ 2,679 | $ 2,180 | $ 3,666 | |
| NPV | $ (41) | |||||
| IRR = 35%+1%*179/(179+41) = | 35.81% | |||||
| 3] | MIRR: | |||||
| FVIF at 12% | 1.40493 | 1.25440 | 1.12000 | 1.00000 | ||
| FV at 12% | $ 5,548 | $ 6,216 | $ 6,143 | $ 12,540 | ||
| Sum of FV of FCF | $ 30,448 | |||||
| MIRR = (30448/11470)^(1/4)-1 = | 27.64% | |||||
| 4] | Profitability index: | |||||
| Sum of PV of cash inflows | $ 19,350 | |||||
| Initial investment | $ 11,470 | |||||
| PI = 19350/11470 = | 1.69 | |||||
| 5] | Payback period: | |||||
| Cumulative cash flows | $ (11,470) | $ (7,521) | $ (2,565) | $ 2,920 | $ 15,460 | |
| Payback period = 2+2565/5485 = | 2.47 | Years | ||||
| 6] | Discounted payback period: | |||||
| Cumulative PV of cash flows | $ (11,470) | $ (7,944) | $ (3,993) | $ (89) | $ 7,880 | |
| Discounted payback period = 3+89/7970 = | 3.01 | Years |
jeff jeffy answered 1 year agoRelated Solutions
MLM Corporation, has provided you the following business operations data: Items Value Equipment cost $8,750 Salvage...
MLM Corporation, has provided you the following business
operations data:
Items
Value
Equipment cost
$8,750
Salvage value, equipment, Year 4
$750
Opportunity cost
$0
Externalities (cannibalization)
$0
Units sold, Year 1
12,000
Annual change in units sold, after Year 1
13%
Sales price per unit, Year 1
$1.65
Annual change in sales price, after Year 1
3%
Variable cost per unit (VC), Year 1
$1.07
Annual change in VC, after Year 1
3%
Nonvariable cost (Non-VC), Year 1
$2,120
Annual...
8) Dipaola Corporation has provided the following data concerning last month's operations.
8) Dipaola Corporation has provided the following data concerning last month's operations. Purchases of raw materials $ 26,000 Indirect materials included in manufacturing overhead $ 6,000 Direct labor cost$ 58,000Manufacturing overhead applied to Work in Process$ 87,000Overapplied overhead $ 6,000 BeginningEndingRaw materials inventory $ 12,000 $ 18,000 Work in process inventory $ 46,000 $ 64,000Finished goods inventory $ 31,000 $ 46,000 How much is the direct materials cost for the mouth on the Schedule of Cost of Goods Manufactured? A) $38,000 B) $32,000 C) $14,000 D) $26,000
Primare Corporation has provided the following data concerning last month’s manufacturing operations.
Primare Corporation has provided the following data concerning last month’s manufacturing operations.
Purchases of raw materials
$
32,000
Indirect materials included in manufacturing overhead
$
4,760
Direct labor
$
58,500
Manufacturing overhead applied to work in process
$
87,700
Underapplied overhead
$
4,150
Inventories
Beginning
Ending
Raw materials
$
10,200
$
18,700
Work in process
$
54,600
$
67,800
Finished goods
$
33,500
$
42,600
Required:
1. Prepare a schedule of cost of goods manufactured...
Primare Corporation has provided the following data concerning last month’s manufacturing operations.
Primare Corporation has provided the following data concerning
last month’s manufacturing operations. Required: 1. Prepare a schedule of cost of goods manufactured for the month. 2. Prepare a schedule of cost of goods sold for the month. Assume the underapplied or overapplied overhead is closed to Cost of Goods Sold.
Primare Corporation has provided the following data concerning last month’s manufacturing operations.
Primare Corporation has provided the following data concerning
last month’s manufacturing operations. Required: 1. Prepare a schedule of cost of goods manufactured for the month. 2. Prepare a schedule of cost of goods sold for the month. Assume the underapplied or overapplied overhead is closed to Cost of Goods Sold.
Primare Corporation has provided the following data concerning last month’s manufacturing operations. Purchases of raw...
Primare Corporation has provided
the following data concerning last month’s manufacturing
operations.
Purchases of raw
materials
$
31,000
Indirect materials
included in manufacturing overhead
$
4,660
Direct labor
$
59,100
Manufacturing
overhead applied to work in process
$
88,300
Underapplied
overhead
$
4,110
Inventories
Beginning
Ending
Raw materials
$
10,500
$
19,400
Work in process
$
55,700
$
67,300
Finished goods
$
33,100
$
42,600
Required:
1.
Prepare a schedule of cost of
goods manufactured for the month....
Cienfuegos Corporation has provided the following data concerning last month’s operations. Purchases of raw materials $...
Cienfuegos Corporation
has provided the following data concerning last month’s
operations.
Purchases of raw
materials
$
36,000
Indirect
materials included in manufacturing overhead
$
4,000
Direct labor
cost
$
58,000
Manufacturing
overhead applied to Work in Process
$
90,000
Overapplied
overhead
$
3,000
Beginning
Ending
Raw materials
inventory
$
10,000
$
21,000
Work in process
inventory
$
62,000
$
70,000
Finished goods
inventory
$
36,000
$
40,000
The company closes out
any underapplied or overapplied manufacturing overhead to cost of...
Primare Corporation has provided the following data concerning last month’s manufacturing operations. Purchases of raw materials...
Primare Corporation has provided the following data concerning
last month’s manufacturing operations. Purchases of raw materials $
32,000 Indirect materials used in production $ 4,690 Direct labor $
59,200 Manufacturing overhead applied to work in process $ 87,000
Underapplied overhead $ 4,170 Inventories Beginning Ending Raw
materials $ 10,800 $ 19,800 Work in process $ 55,200 $ 66,800
Finished goods $ 35,000 $ 42,800
Required: 1. Prepare a schedule of cost of goods manufactured
for the month.
2. Prepare a...
Primare Corporation has provided the following data concerning last month’s manufacturing operations. Purchases of raw materials...
Primare Corporation has provided the following data concerning
last month’s manufacturing operations.
Purchases of raw materials
$
31,000
Indirect materials included in manufacturing overhead
$
4,550
Direct labor
$
58,600
Manufacturing overhead applied to work in process
$
88,100
Underapplied overhead
$
4,150
Inventories
Beginning
Ending
Raw materials
$
11,900
$
18,800
Work in process
$
54,600
$
68,100
Finished goods
$
33,300
$
43,000
Required:
1. Prepare a schedule of cost of goods manufactured for the
month.
2. Prepare...
Primare Corporation has provided the following data concerning last month’s manufacturing operations. Purchases of raw materials...
Primare Corporation
has provided the following data concerning last month’s
manufacturing operations.
Purchases of raw
materials
$
31,000
Indirect
materials used in production
$
4,510
Direct
labor
$
58,100
Manufacturing
overhead applied to work in process
$
88,600
Underapplied
overhead
$
4,170
Inventories
Beginning
Ending
Raw
materials
$
10,800
$
19,700
Work in
process
$
54,700
$
65,000
Finished
goods
$
34,700
$
43,500
Required:
1. Prepare a schedule
of cost of goods manufactured for the month.
2. Prepare a...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- If you want to do live streaming on a computer, what are hardware components that you...
- Create a project that illustrates your understanding of ONE of the following concepts related to biological...
- 1.What is meant by limited liability? 2.Why do most professionals consider the Wilshire 5000 a better...
- (a) Your daughter has expressed a wish to attend university when she finishes school in five...
- (c) You have commenced work as a certified Financial Planner. Your supervisor has provided the following...
- Elders with PEM will likely present with? Obesity, anemia, and elevated serum cholesterol Recent weight gain,...
- 1.USA is getting older. In retirement, do families have a higher or lower income than other...
ADVERTISEMENT