Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Option A. $22,000,000,00 received today. Option B: 24 payments of $1,717,303.12 at the start of every year for 24 years, with the first payment today,

image text in transcribed
Option A. $22,000,000,00 received today. Option B: 24 payments of $1,717,303.12 at the start of every year for 24 years, with the first payment today, The nominal annual interest rate is (14)=8000%. Kelko wants you to advise them which option to choose. a) Build a spreadsheet (see the posted example) to compare the present value of the 2 options. Which woild you recommend? b) Suppose instead you assumed they woutd never spend any of the money, instead saving it al until the time of the last payment of Option B. Find the future value of both options at this time. Would this calculation change your recommendation? c) If the interest tale were ([1)=3.000W instead, woud that change which option you recommend? d) Obviously there is some interest rate itu at which the present value of the two options is the same. Find that value (aceurate to 3 decimal places, n.g. 3.456s) using either trial and errof or goal seek fWarning if you are using trial and error using orly 3 decimal places for the interest rate, the present values you compute might not mateh exactlyt)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Forecasting Principles And Practice

Authors: Rob J Hyndman, George Athanasopoulos

3rd Edition

0987507133, 978-0987507136

More Books

Students also viewed these Finance questions