I need help, please show me how you can get the answers using excel functions...

80.2K

Verified Solution

Question

Finance

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

- 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
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

Other questions asked by students