You are manager of a manufacturing business. Business is going very well and one production line...

60.1K

Verified Solution

Question

Finance

You are manager of a manufacturing business. Business is goingvery well and one production line is at full capacity. You want todouble the size of the production line. Engineering has estimatedthe cost and time required. It can be accomplished withouteffecting the existing production. The timing of the cash flows forthe facility is as follows.

Month

Cash Flow

1

$       (20,000.00)

2

$       (45,000.00)

3

$       (55,000.00)

4

$       (70,000.00)

5

$       (75,000.00)

6

$       (80,000.00)

7

$       (90,000.00)

8

$       (90,000.00)

9

$     (120,000.00)

10

$     (140,000.00)

11

$     (180,000.00)

12

$     (200,000.00)

13

$     (225,000.00)

14

$     (175,000.00)

15

$     (200,000.00)

16

$       (50,000.00)

Total

$ (1,815,000.00)

The current cost of capital is 9% APR. What is the total cost ofthe project?

You pay interest on the project every year (i.e., you do not payoff the capital, only the interest.) Calculate the total projectcost including interest. Use annual numbers to calculate theinternal rate of return.

Sales start after the project is completed. You estimate thatsales for the first year will be at 30% of capacity and increase to60% in year 2. Sales after year 2 are estimated at 85% of capacity.The current production line generates $1,100,000 in net profit. Theprofit at 30% is 0. The profit above 30% will be proportional tothe percent capacity utilized. The company demands a minimum 20%internal rate of return for capital projects. Does the 10-year rateof return meet the company requirements? Assume that the companypays interest on the capital for the entire ten years. (Showcorrect total project cost including Interest, 10 year cash flow,and IRR for project)


Please identify formulas and explain why. Thankyou!

Answer & Explanation Solved by verified expert
4.2 Ratings (677 Votes)
Month n Cash Flow IntCash flow916n12 1 20000 2250 2 45000 4725 3 55000 5363 4 70000 6300 5 75000 6188 6 80000 6000 7 90000 6075 8 90000 5400 9 120000 6300 10 140000 6300 11 180000 6750 12 200000 6000 13 225000 5063 14 175000 2625 15 200000 1500 16 50000 0 Total 1815000 76838 1891838 Total capital inclint at timt mth 16 end1815000768381891838 Future value at time mth    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

You are manager of a manufacturing business. Business is goingvery well and one production line is at full capacity. You want todouble the size of the production line. Engineering has estimatedthe cost and time required. It can be accomplished withouteffecting the existing production. The timing of the cash flows forthe facility is as follows.MonthCash Flow1$       (20,000.00)2$       (45,000.00)3$       (55,000.00)4$       (70,000.00)5$       (75,000.00)6$       (80,000.00)7$       (90,000.00)8$       (90,000.00)9$     (120,000.00)10$     (140,000.00)11$     (180,000.00)12$     (200,000.00)13$     (225,000.00)14$     (175,000.00)15$     (200,000.00)16$       (50,000.00)Total$ (1,815,000.00)The current cost of capital is 9% APR. What is the total cost ofthe project?You pay interest on the project every year (i.e., you do not payoff the capital, only the interest.) Calculate the total projectcost including interest. Use annual numbers to calculate theinternal rate of return.Sales start after the project is completed. You estimate thatsales for the first year will be at 30% of capacity and increase to60% in year 2. Sales after year 2 are estimated at 85% of capacity.The current production line generates $1,100,000 in net profit. Theprofit at 30% is 0. The profit above 30% will be proportional tothe percent capacity utilized. The company demands a minimum 20%internal rate of return for capital projects. Does the 10-year rateof return meet the company requirements? Assume that the companypays interest on the capital for the entire ten years. (Showcorrect total project cost including Interest, 10 year cash flow,and IRR for project)Please identify formulas and explain why. Thankyou!

Other questions asked by students