Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Time value of moneya. Finding FVInvestment ( PV ) $ 1 , 0 0 0 Interest rate ( I ) 8 % Number of years

Time value of moneya. Finding FVInvestment (PV)$1,000Interest rate (I)8%Number of years (N)6FormulaFuture value (FV)#N/Ab. Creating a table with FVs at various interest rates and time periods using Data TableFormulasYear (B6)Interest Rate (B5)Year (B6)Interest Rate (B5)0%4%20%#N/A0%4%20%00#N/A#N/A#N/A11#N/A#N/A#N/A22#N/A#N/A#N/A33#N/A#N/A#N/A44#N/A#N/A#N/A55#N/A#N/A#N/ACreating a graph with years on the horizontal axis and FV on the vertical axisc. Finding PVFuture value (FV)$1,000Discount rate (I)8%Number of years (N)6FormulasPresent value (PV)#N/Ad. Finding the rate of return provided by the securityCost of security (PV)$1,000Future value of security (FV)$2,000Number of years (N)6Rate of return (I)#N/Ae. Calculating the number of years required to double the populationCurrent population in millions (PV)34.5Growth rate (I)4%Doubled population in millions (FV)#N/ANumber of years required to double (N)#N/Af. Finding the PV and FV of an ordinary annuityAnnuity (PMT)$1,000Interest rate (I)13%Number of years (N)6Present value of ordinary annuity (PV)#N/AFuture value of ordinary annuity (FV)#N/Ag. Recalculating the PV and FV for part f if the annuity is an annuity duePresent value of annuity due (PV)#N/AFuture value of annuity due (FV)#N/Ah. Recalculating the PV and the FV for parts a and c if the interest rate is semiannually compoundedFuture value (FV)#N/APresent value (PV)#N/Ai. Finding the annual payments for an ordinary annuity and an annuity duePresent value (PV)$1,000Discount rate (I)6%Number of years (N)12Annual payment for ordinary annuity (PMT1)#N/AAnnual payment for annuity due (PMT2)#N/Aj. Finding the PV and the FV of an investment that makes the following end-of-year paymentsYearPayment1$2002$4003$600Interest rate (I)6%Present value of investment (PV)#N/AFuture value of investment (FV)#N/Ak. Five banks offer the same nominal rate on deposits, but A pays interest annually, B pays semiannually, C pays quarterly, D pays monthly, and E pays daily.(1) Calculating the effective annual rate for each bank and the future values of the deposit at the end of 1 year and 2 yearsNominal rate (INOM)4%Deposit (PV)$4,000Number of days per year365FormulasABCDEABCDEEAREAR#N/A#N/A#N/A#N/A#N/AFV after 1 yearFV after 1 year#N/A#N/A#N/A#N/A#N/AFV after 2 yearsFV after 2 years#N/A#N/A#N/A#N/A#N/A(2) Calculating the nominal rates that will cause all of the banks to provide the same effective annual rate as Bank ABCDEBCDENominal rate (INOM)Nominal rate (INOM)#N/A#N/A#N/A#N/A(3) Calculating the amount of payment to be made annually for A, semiannually for B, quarterly for C, monthly for D, and daily for ENeeded amount (FV)$4,000Number of years (N)1ABCDEABCDEPayment (PMT)Payment (PMT)#N/A#N/A#N/A#N/A#N/Al. Setting up the amortization scheduleOriginal amount of mortgage (PV)$14,000Interest rate (I)6%Term to maturity, years (N)4FormulaAnnual payment (PMT)#N/AFormulasYearBeginning BalancePaymentInterestRepayment of PrincipalEnding BalanceYearBeginning BalancePaymentInterestRepayment of PrincipalEnding Balance11#N/A#N/A#N/A#N/A#N/A22#N/A#N/A#N/A#N/A#N/A33#N/A#N/A#N/A#N/A#N/A44#N/A#N/A#N/A#N/A#N/ACreating a graph that shows how the payments are divided between interest and principal repayment over time

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these Finance questions