80.2K

Verified Solution

Link Copied!

I need help, please show me how you can get the answers using excel functions for these questions that have the answers provided:

- What is the NPV of a project that costs $1626 and pays $1308, $2310, and $1787 at years 1 to 3 , respectively. The one-year forward rates ( 0 to 1,1 to 2 , and 2 to 3 ) are: 2.8%,4.8% amd 9.5%, respectively. Give your answer in dollars to the nearest penny. Selected Answer: $3,110.69 Correct Answer: 3,305.340.01 estion 2 1 out of 2 points Which capital budgeting criteria are invariant to project cash flow patterns? (i.e., the same criteria is applied to projects with conventional cash flow patterns as to projects with non-conventional cash flow patterns) Selected Answers: IRR NPV Correct Answers: Payback Period NPV estion 3 2 out 2 points What's the profitability index of a project that costs $4418 and then generates $523 per year for 4 years? The discount rate is 9.4%. Give your answer to two decimal places Selected Answer: 0.38 Correct Answer: 0.380.01 estion 4 2 out of 2 points Footsteps Co. has a bond outstanding with a coupon rate of 5.6 percent and annual payments. The bond currently sells for $923.84, matures in 12 years, and has a par value of $1,000. What is the YTM of the bond? Selected Answer: 6.54% Correct Answer: 6.54%

Answer & Explanation Solved by verified expert

See Answer