Question

In: Accounting

Can this be written out please, for my Bath Uni homework. Cash Flow Analysis. You are...

Can this be written out please, for my Bath Uni homework.

Cash Flow Analysis. You are considering a 5-year investment project which is expected to cost $1, 000, 000. In each year, you have decided that there are 3 possible states of the economy: good, average, and poor. In each individual year there is a 35% chance of the economy being good and a 15% chance of it being poor. You forecast the following net cash flows for the project:

Economy Year 1 Year 2 Year 3 Year 4 Year 5

Good 300,000 350,000 400,000 350,000 250,000

Average 250,000 275,000 325,000 275,000 175,000

Poor 200,000 225,000 250,000 225,000 150,000

(a) What is the expected net cash flow each year? You have arranged the following sources of funding:

(i) $200,000 from a 5-year fixed interest loan whose annual loan payments are $48,126.91.

(ii) $250,000 from a 5-year zero-coupon bond with a face value of $350,000.

(iii) $300,000 from an ordinary share issue where a dividend of $18,000 will be paid in one year and it is expected to grow at 3% per annum.

(iv) $250,000 from a 5-year coupon-paying bond issue whose coupon rate is 7% and face value is $250,000.

(b) what is the discount rate given above sources of financing? Hint: The discount rate should be the weighted average cost of capital.

(c) What is the NPV of this investment project and should you invest in this project?

Solutions

Expert Solution

Answer:

(a) Expected Cash Flow:

Year 1= 260,000

Year 2= 293,750

Year 3= 340,000

Year 4= 293,750

Year 5= 197,500

Details as follows:

(b) Calculation of Discount rate (WACC):

(i) Cost of loan (Rl)= 6.5% as follows:

Weight of loan in capital structure (Wl)= 200,000/1,000,000 =0.2

(ii ) Cost of Zero coupon Bond (Rz) = (350,000/250,000)^(1/5) – 1= 6.96104%

Weight of Zero coupon Bond in capital structure (Wz)= 250,000/1,000,000 =0.25

(iii ) Cost of equity share (Re) = 9.18% as follows:

Weight of equity in capital structure (We)= 300,000/1,000,000 =0.30

(iv ) Cost of coupon bond is the coupon rate since the price is equal to face value (issue at par). Hence cost of coupon bond (Rb)= 7%

Weight of coupon bond in capital structure (Wb)= 250,000/1,000,000 =0.25

Discount Rate (WACC)= Wl*Rl + Wz*Rz + We*Re +Wb*Rb

= 0.2*6.5% + 0.25*6.96104% + 0.30*9.18% + 0.25*7%

= 7.54426%

(c):

NPV of the project= $ 125,977.78 as follows:

Since NPV is positive, we shall invest in the project.

If you do not get anything in this solution, please put a comment and I will help you out.
Do not give a downvote instantly. It is a humble request. If you like my answer, please give an upvote.


Related Solutions

What is a cash flow statement and a cash flow analysis? Please provide a visual example.
What is a cash flow statement and a cash flow analysis? Please provide a visual example.
Can you please write a written detailed procedure for the two experiments: 1- qualitative analysis of...
Can you please write a written detailed procedure for the two experiments: 1- qualitative analysis of cation group 1 2- qualitative analysis of cation group 2
PLEASE NO COPIED OR HAND WRITTEN ANSWERS Describe what directly impacts the cash flow of a...
PLEASE NO COPIED OR HAND WRITTEN ANSWERS Describe what directly impacts the cash flow of a business?
Please finish this code and make it work. This is my homework and my professor wont...
Please finish this code and make it work. This is my homework and my professor wont allow me to change the code in main, it's a set of huge numbers need to sort by radixsort with bit operation. #include <iostream> using namespace std; void radixLSD_help(int *items, int length, int bit) {    // – Count number of items for each bucket.    // – Figure out where each bucket should be stored (positions // of the first and last element...
Hi! Thanks for taking the time to check out my problem. If you can please answer...
Hi! Thanks for taking the time to check out my problem. If you can please answer as many as possible and I really appreciate your help. Question 6 2 pts In an agricultural study, the average amount of corn yield is normally distributed with a mean of 189.3 bushels of corn per acre, with a standard deviation of 23.5 bushels of corn. If a study included 1200 acres, about how many would be expected to yield more than 180 bushels...
You can determine a company's cash situation by analyzing the cash flow statement. The cash flow ...
You can determine a company's cash situation by analyzing the cash flow statement. The cash flow statement also helps determine whether the company (1) is generating enough cash from its operations to make new investments and pay dividends or (2) will need to generate cash by issuing new debt or selling its assets. A firm has $100 million in revenues. Does that mean it has generated a cash flow of $100 million? No Yes Three categories of activities (operating, investing, and financing) generate or...
Can I please get a step by step (either video or written out) for this question....
Can I please get a step by step (either video or written out) for this question. I don't know where to find the step by step videos. They are EXTREMELY helpful. The inverse demand for a homogeneous-product Stackelberg duopoly is P = 16,000 -4Q. The cost structures for the leader and the follower, respectively, are CL(QL) = 3,000QL and CF (QF) = 6,000QF.. a. What is the follower’s reaction function? b. Determine the equilibrium output level for both the leader...
SE 4367, Software Testing Homework #10, Control Flow Coverage For the following program P written in...
SE 4367, Software Testing Homework #10, Control Flow Coverage For the following program P written in pseudo-code, given the test set T: T = {t1 = <4, 2>, t2 = <90, 0>, t3 = <56, 1>} What is the statement coverage for T? What is the block coverage for T? What is the decision coverage for T? What is the condition coverage for T? What is the condition/decision coverage for T? Program P integer X, Y, Z; input (X, Y);...
Capital budgeting and cash flow analysis
Th e Taylor Mountain Uranium Company currently has annual cash revenues of $1.2 millionand annual cash expenses of $700,000. Depreciation amounts to $200,000 per year.Th ese fi gures are expected to remain constant for the foreseeable future (at least 15 years).Th e fi rm’s marginal tax rate is 40 percent.A new high-speed processing unit costing $1.2 million is being considered as a potentialinvestment designed to increase the fi rm’s output capacity. Th is new piece of equipmentwill have an estimated...
How do we use horizontal analysis with the cash flow statement? What can this analysis reveal...
How do we use horizontal analysis with the cash flow statement? What can this analysis reveal about a company?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT