I need help on finding my errors within the project Excell workbook. When I go online to submit an attempt,I am scoring 84 out of 100 points. So several of my answers are wrong.I will past the multiple choice answer file below.,, Question 1 , ,[Q #1 ] Net Present Value for "A" is (using a 15% discount rate) :,Answer , , -$357, , $357, , $411, , -$4,110, , $839, , $556,4 points , Question 2 , ,[Q #3 ] Internal Rate of Return for "A" is,Answer , , 23.47%, , -19.2%, , -5.9%, , 25.44, , 15.22%,4 points , Question 3 , ,[Q #2 ] Net Present Value for "B" is (using a 12% discount rate):,Answer , , $396, , -$354, , -$462, , $188, , $3,960, , -$39,500,4 points , Question 4 , ,[Q #4 ] Internal Rate of Return for "B" is,Answer , , 15.22%, , -15.22%, , -23.4, , 23.4%.,4 points , Question 5 , ,[Q # 7] Given a borrower has $385,000 per year to pay on a loan and given the lenders debt coverage ratio of 1.3, what is the amount the lender will allow the borrow to allocate toward a loan? (per year) ,Answer , , $385,000, , $536,000, , $22,333, , $296,154,4 points , Question 6 , ,[Q # 6] What is the after tax, after CapEx cash flow able to service a loan? ,,Answer , , $506,670, , $609,344, , $296,670, , -$184,960,4 points , Question 7 , ,[Q # 5 ] Net Present Value of the after tax cash flows on the pro forma is,Answer , , -$1,520,311, , -$1,648,334, , -1,420,978, , 1,462,802, , $1,520,311,4 points , Question 8 , ,[Q # 8] The total amount of debt that can be serviced if $100,000 is paid each period. (Restated: Given PMT = $100k, i = 10%, n = 15, what is the loan amount (using annual compounding)),Answer , , $2,375,250, , $760,607, , $76,923, , $1,257,750, , $1,500,000,3 points , Question 9 , ,[Q #9 ] Given the data on worksheet "Q9 – 13", What is the WACC of company "XYZ"?,Answer , , 12.18%, , 11.19%, , 10.4, , 12.0%,4 points , Question 10 , ,[Q # 10] Calculate CAPM based on "XYZ" common equity based on the data provided.,Answer , , 11.4 %, , 17.5%, , 13%, , 12.04%,4 points , Question 11 , ,[Q # 12] What is the payback for project "M". (If you like, you can use a 20% discount rate).,Answer , , about $734k, , $5,803 (Present value), , 6 years, , 16%,4 points , Question 12 , ,{Q # 13] Comparing the net income yield to a CD or risk free rate of 6%, does project "M" beat the risk free rate? Compare year one if you consider the Net Income versus the Price paid for project "M".,Answer , , Yes, , No, , 6%, , Trick question!,4 points , Question 13 , ,[Q # 11] What is the appropriate discount rate to evaluate this opportunity (of those provided here)?,Answer , , Cost of marginal debt, , the average return for the stock market (knowing XYZ is a public company)., , Beta of XYZ times the stock market average., , Since the risk of the project is not given, it will be assumed it is riskier that a diversified portfolio; therefore, the discount rate is greater than 17.5%,4 points , Question 14 , ,[Q # 15 ] Ranking the projects (highest to lowest) according to IRR,Answer , , N, O, P, Q, , Q, P, N, O, , P, N, Q, O, , O, P, N, Q, , P, N, O, Q,4 points , Question 15 , , [ Q #16 ] Ranking projects (earliest to latest) using the payback method,Answer , , Q, P, O, N, , Q, O, P, N, , O, N, Q, P, , P, N, Q, O,4 points , Question 16 , ,[Q #14 ] Ranking the projects (highest to lowest) according to NPV,Answer , , N, O, P, Q, , O, P, Q, N, , P, O, N, Q, , P, N, Q, O,4 points , Question 17 , ,[Q #19 ] What is the pro forma revenue calculated for year 5?,Answer , , $896,580, , $210,311, , $473,508, , $143,644, , $2,406,820,4 points , Question 18 , ,[Q # 25 ] What is the IRR of this acquisition?,Answer , , 18.2%, , 15%, , Cannot be determined, , 8%,4 points , Question 19 , ,[Q # 24 ] Using the given discount rate, what is the NPV of the acquisition? (Use your equity investment (your cash out of pocket) and the cash flows from the opportunity),Answer , , $1,690,126, , $2,154,294, , $6,482, , $714,213,4 points , Question 20 , ,[Q #17] What is the purchase Price of the acquisition?,Answer , , $30,000,000, , $11,100,000, , $2,835,000, , $6,000,000,4 points , Question 21 , ,[Q #18 ] What is the Goodwill Amount of the Purchase Price?,Answer , , $88,750, , $1,775,000, , $1,060,000, , -$1,060,000, , Does not exist in this problem.,4 points , Question 22 , ,[Q # 22 ] What is the net cash flow for year 2? (after debt service and CapEx),Answer , , $131,179, , $420,575, , -$1,991, , $64,512, , $861,840,4 points , Question 23 , ,[Q #23 ] Without considering any principal payments or capital expenditures, what is the cash flow for the seller in the year of the sale?,Answer , , $64,512, , $364,000, , $187,000, , -$2,457, , Cannot determine from the information; but seller was not profitable and that is why he is selling.,4 points , Question 24 , ,[Q # 21] What is the net income for year 1?,Answer , , $117,592, , $330,217, , -$1,991, , $64,675,4 points , Question 25 , ,[Q #20 ] What is the principal portion of your debt payment in year 8?,Answer , , $330,750, , $212,625, , $0, , $512,750,4 points , Question 26 , ,[Q # 26 ] Considering the "math answer only", do we make the acquisition?,Answer , , no, , maybe, , yes,Bottom of Form,

Order Your Custom Essay

Order Your Custom Essay

Regent Papers is a library of common essays on high school, college, undergraduate and postgraduate topics. We have collected top papers from various institution, students and professors. The papers are based on common essay topics in all subjects.

M | T | W | T | F | S | S |
---|---|---|---|---|---|---|

« Oct | ||||||

1 | 2 | 3 | 4 | 5 | ||

6 | 7 | 8 | 9 | 10 | 11 | 12 |

13 | 14 | 15 | 16 | 17 | 18 | 19 |

20 | 21 | 22 | 23 | 24 | 25 | 26 |

27 | 28 | 29 | 30 | 31 |

2922 Oak Grove Drive La CaĆ±ada Flintridge, CA 91521.

+2 54723059803 (text only-sms)

© 2015 www.regentessays.com. All Rights Reserved