PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS 1.-  Osmara Del Toro deposits her life savings working at HoneyBee for $545,000, for when her retirement day arrives in 6 years, 6 months 6 days. The contract stipulates the payment of interest capitalizable quarterly, at a rate of 10.¼ %. What is the amount she will have at the end of the term that will provide welfare in her old age?

Q: Ryan obtain a nine year subsidized loan of $26,000 at an annual interest rate of 4%. If Ryan…

A: Here, Loan Amount is $26,000 Annual Interest Rate is 4% Income Adjusted Repayment is $275 per month

Q: You decide to open an individual retirement account (IRA) at your local bank that pays 8%/year…

A: A theory that helps to compute the present or future value of the cash flows is term as the TVM…

Q: Congratulations - you have secured your first job after graduating from Isenberg. Your employer is…

A: The objective of the question is to find the unknown annuity amount for the second option that would…

Q: Kelly Malone plans to have $55 withheld from her monthly paycheck and deposited in a savings account…

A: Monthly payment=$55Interest rate=12%Compounding monthlyMonthly rate=r=12/12=1%Period=1.5 yearsn=1.5…

Q: You have opened a financial instrument that requires the following for the next six years: An…

A: Annuity refers to series of equalized payments that are paid or received at start or ending of…

Q: One month from​ now, Kelly will make her first monthly contribution of ​$250 to a​ Tax-Free…

A: Future value = $55,000Interest rate = 7% compounded annuallyMonthly contributions = $250

Q: Kelly Malone plans to have $53 withheld from her monthly paycheck and deposited in a savings account…

A:

Q: NOTE: Provide a format and show your work (example: N = 6, PV = XXX, I = X%, etc.) 1. Sam decides…

A: Step 1 The current value of a future stream of payments from a business, project, or investment is…

Q: In order to accumulate enough money for a down payment on a​ house, a couple deposits $ 234 per…

A: Here, The future value is "FV". The periodic payments are "P". The interest rate is "r". The…

Q: 2. An employee plans on working and contributing to his retirement account monthly for 32 years and…

A: Annuity refers to series of equalized payments that are received or paid either at start or end of…

Q: o acquires a loan of $300,000 to be paid off during 6 years with monthly payments. If the…

A: Monthly payments are equal fixed amount of payment that carry the payment for interest and loan but…

Q: Amy is going to contribute $150 per month to her retirement account, starting one month from today.…

A: Here, Particulars Values Own contribution   $ 150.00 Employer's contribution  $ 150.00…

Q: When Jasmine retires she has $950,000 in a retirement account that earns 6% annual interest,…

A: Using PMT function in excel

Q: Ms. C took a loan of $150,000 at a rate of 7 percent. She can pay equal installments of $25,000 at…

A: PV(loan amount) = 150,000I/Y (interest rate) = 7%PMT (periodic payment) = 25,000

Q: An engineer who is saving for her retirement plans to deposit $500 every semiannually, starting…

A: Semi Annual Deposit = 500 End of period deposits Nominal Rate = 12℅ Quarterly Compounding N = 25…

Q: If you make an equal deposit at the end of every year to the account for the next 40 ears, what is…

A: Future value required=$8000000Period=n=40 yearsInterest rate=8%

Q: Megan invests $1, 500 at the end of each year into an account earning 2% effective annual interest.…

A: Part 1:  Future value of the annuity in the first accountYear Amount Deposited0 $1,5001 $1,5002…

Q: In order to accumulate enough money for a down payment on a house, a couple deposits $244 per month…

A: Future value refers to the future worth of a present sum. Annuity refers to the periodic payment…

Q: Alexandria has $400,000 saved for retirement in an account earning 2.45% interest, compounded…

A: Solution:- When an equal amount is withdrawn each period, it is called annuity. We know, present…

Q: Suppose a recent college graduate's first job allows her to deposit $250 at the end of each month in…

A: The monthly deposit is $250. Interest per months is (9% ÷ 12) = 0.75%. The formula to calculate…

Q: After completing a bachelors degree, you have $15,000.00 in student loans to pay back at an interest…

A: Calculating the Monthly Payment on a Student LoanWe can calculate the monthly payment on the student…

Q: Kelly Malone plans to have $58 withheld from her monthly paycheck and deposited in a savings account…

A: Given Periodic Cash flow = $ 53 Table values are based on  n = 18 periods   (1.5 yrs *12) i= 1% (12%…

Q: In order to accumulate enough money for a down payment on a house, a couple deposits $668 per month…

A:

Q: Joshua plans to retire in 25 years. He will make 15 years of equal monthly payments into his…

A: The term "annuity" refers to a contract created and offered by financial institutions with the goal…

Q: Alejandra Marrufo wants to know how much she should deposit today, so that in 10 years she will have…

A: Time value of money (TVM) refers to the concept which proves that the value of money today is higher…

Present Value

Present value (PV) is defined as the current or present value of all future sums of cash flow or money at a specified rate of return. This rate of return is known as the discounted rate, which is essentially the interest rate, discounted over some time. The expected cash flows are discounted at a discount rate to compute the present value. The higher the discount rate, the higher the future value (FV), but the lower the present value.