Your manager is proposing a new investment. If the company pursues the investment, it will cost...

Your manager is proposing a new investment. If the company pursues the investment, it will cost $300,000 today. It has an expected life of 10 years and no salvage value. Annual expenses are estimated to be $30,000 per year. Annual revenue increases are estimated to be $70,000 per year. Your company must borrow 1/3 of the investment cost. The bank has agreed to six equal annual payments, with the first payment due at the end of year 1. The company's MARR is 10% compounded annually. The loan interest rate is 12% compounded annually.

create in excel file

a) How much is the loan payment?

b) What is the present worth of this investment opportunity?

c) Based on the present worth analysis, should the company make the investment? Why or why not?

Solutions

Expert Solution

Using Excel

Year	investment	Loan payment	Annual revenue	Annual cost	Net cash flow
0	-200000				-2,00,000.00
1		-24,322.57	70,000.00	-30,000.00	15,677.43
2		-24,322.57	70,000.00	-30,000.00	15,677.43
3		-24,322.57	70,000.00	-30,000.00	15,677.43
4		-24,322.57	70,000.00	-30,000.00	15,677.43
5		-24,322.57	70,000.00	-30,000.00	15,677.43
6		-24,322.57	70,000.00	-30,000.00	15,677.43
7			70,000.00	-30,000.00	40,000.00
8			70,000.00	-30,000.00	40,000.00
9			70,000.00	-30,000.00	40,000.00
10			70,000.00	-30,000.00	40,000.00
				NPW	-60,148.46

A. Annual Loan payment for 6 years = 24322.57

B. NPW = -60148.46

C. This project should not be selected as NPW is negative

Showing formula

Year	investment	Loan payment	Annual revenue	Annual cost	Net cash flow
0	-200000				=B3+C3+D3+E3
1		=PMT(12%,6,100000)	70000	-30000	=B4+C4+D4+E4
2		=PMT(12%,6,100000)	70000	-30000	=B5+C5+D5+E5
3		=PMT(12%,6,100000)	70000	-30000	=B6+C6+D6+E6
4		=PMT(12%,6,100000)	70000	-30000	=B7+C7+D7+E7
5		=PMT(12%,6,100000)	70000	-30000	=B8+C8+D8+E8
6		=PMT(12%,6,100000)	70000	-30000	=B9+C9+D9+E9
7			70000	-30000	=B10+C10+D10+E10
8			70000	-30000	=B11+C11+D11+E11
9			70000	-30000	=B12+C12+D12+E12
10			70000	-30000	=B13+C13+D13+E13
				NPW	=NPV(10%,F4:F13)+F3

Rahul Sunny answered 1 year ago

Next > < Previous

Related Solutions

9. If the company pursues the investment opportunity and otherwise performs the same as last year,...

9. If the company pursues the investment opportunity and otherwise performs the same as last year, what ROI will it earn this year? (PERCENT) 10-a. If Westerville’s chief executive officer will earn a bonus only if her ROI from this year exceeds her ROI from last year, would she pursue the investment opportunity? (Y/N) 10-b. Would the owners of the company want her to pursue the investment opportunity? (Y/N) 11. What is last year’s residual income? 12. What is the...

Please respond to the following questions in your reflective journal: As a manager proposing a project...

Please respond to the following questions in your reflective journal: As a manager proposing a project (e.g. new product, expansion of existing business activity, exit from a current location), how would you address decision makers who do not understand time value of money? What concepts/requirements have proven to be most difficult? What do you need to do to overcome the challenge? What assistance do you need from the instructor to succeed?

Provide one example of a company that pursues a niche differentiation strategy and one that pursues...

Provide one example of a company that pursues a niche differentiation strategy and one that pursues a broad cost-leadership strategy. Explain

(a)Suppose you are the risk manager for a company considering a $5,250,000 investment in a new...

(a)Suppose you are the risk manager for a company considering a $5,250,000 investment in a new 12-year project. The$5.25 million cost of the project will be depreciated on a straight- line basis over 5 years. The project is expected to generate positive operating cash flows equal to S1,600,000 per year(not including the effect of depreciation or taxes). The company's tax rate is 21%. Ignoring any risk management considerations,evaluate the project by calculating its net present value and internal rate of...

If the company pursues the investment opportunity and otherwise performs the same as last year, what margin will it earn this year?

Westerville Company reported the following results from last year’s operations: Sales $ 1,500,000 Variable expenses 730,000 Contribution margin 770,000 Fixed expenses 470,000 Net operating income $ 300,000 Average operating assets $ 937,500 At the beginning of this year, the company has a $362,500 investment opportunity with the following cost and revenue characteristics: Sales $ 580,000 Contribution margin ratio 70 % of sales Fixed expenses $ 319,000 The...

"A manufacturing company is considering a new investment in a machine that will cost $170,000 and...

"A manufacturing company is considering a new investment in a machine that will cost $170,000 and has a maintenance cost of $5,700 that occurs every 2 years starting at the end of year 2. Assuming that this equipment will last infinitely under these conditions, what is the capitalized equivalent cost of this investment at the rate of 13.6%? Enter your answer as a positive number."

If you were the financial manager of this tourism company, would you authorize for new investment?...

If you were the financial manager of this tourism company, would you authorize for new investment? What calculations might you use to value the potential of the new investment? What pitfalls are associated with each type of capital budgeting: net present value, internal rate of return, and payback? How does each type of capital budgeting, and associated pitfalls, influence investment decisions?

A company is considering an investment proposal to install new milling controls at a cost of...

A company is considering an investment proposal to install new milling controls at a cost of GHC 50,000. The facility has a life expectancy of 5 years and no salvage value. The tax rate is 35% . assume the firm uses straight line depreciation and the same is allowed for tax purposes. The estimated cash flows before depreciation and tax( CFBT) from the investment proposal are as follows: Year CFBT 1 GHC 10000 2 10692 3 12769 4...

Question 1 "A manufacturing company is considering a new investment in a machine that will cost...

Question 1 "A manufacturing company is considering a new investment in a machine that will cost $142,000 and has a maintenance cost of $6,600 that occurs every 2 years starting at the end of year 2. Assuming that this equipment will last infinitely under these conditions, what is the capitalized equivalent cost of this investment at the rate of 13.3%?

You are marketing manager for a noodle company. Your company is launching a new noodle soon...

You are marketing manager for a noodle company. Your company is launching a new noodle soon called ‘Amazing Thai’. This noodle tastes delicious and uses Thai ingredient. Define the term “target market”, and suggest a potential target market for new ‘Amazing Thai” noodle in 300 words.

Subjects