ls answer  very faast.I ll upvote. Thank You Bobbie has $6,000 that she wants to invest today to grow into $50,000. She finds an investment that earns 8.5% with quarterly compounds. How many years will she wait till she has the $50,000? Group of answer choices 25.99 years 28.00 years 25.21 years 100.83 year Please answer using excel function for NPER

Q: You currently have $20,000 saved for retirement and can afford to put aside $5,000 per year (end of…

A: Given information,Present value: Payment per period: Future value: Years:  yearsTo derive,Future…

Q: You have just inherited $530,000. You plan to save this money and continue to live off the money…

A: Present value = pv = $530,000 Interest rate = r = 5.30% Future value = fv = $1,000,000   Time = t =…

Q: HELP ME THIS USING EXCEL'S RIBBON PLS USE EXCEL!!! INCLUDE FORMULA AS WELL

A: Amortisation table: A loan amortization table is a table that shows the schedule of payments and…

Q: 6.4 Purchase a Home 1. Tammy and JD are buying a $465,000 home. They have been approved for a 6.25%…

A: Home value = $465,000Mortgage period = 30 yearsDown payment = 30% = 465000 * 0.3 = $139,500Loan…

Q: .If you invest Rs. 1,200 at an annual interest rate of 8%, how much will you have in 3 years if the…

A: Initial investment (I) = 1,200Annual interest rate (r) = 0.08 or 8%Period (n) = 3 YearsValue in 3…

Q: Alec, Daniel, William, and Stephen decide today to save for retirement. Each person wants to retire…

A: The concept of TVM will be used and applied here.TVM refers to time value of money.

Q: Your girlfriend just won the Florida lottery. She has the choice of $13,300,000 today or a 20-year…

A: She has the choice to receive $13,300,000 today or a 20-year annuity of $1,050,000.Therefore, the…

Q: Bill plans to deposit $1,500 quarterly for 30 years at 5.5% Interest, compounded monthly. How much…

A: Formula for computing the amount Future value of series=PMT×p1+rnnt-1rn where 'p' is the number of…

Q: 2. Adam's Awesome Pawnshop will lend up to 42% of the value of a borrower's collateral. Andy wants…

A: Considering the expression as: Adam's Pawnshop lends upto 42% of the value of the collateral of…

Q: Question: compounded You have $1,000,000 saved for retirement in an investment account which pays…

A: Solution: An equal amount saved each period is known as annuity. Present value of annuity = PMT x…

Q: Lisa Anderson deposits $3,400 in her bank today. a. ง If the bank pays 4 percent interest per year…

A: Step 1: Given Value for Calculation Present Value = pv = $3400Interest Rate = r = 4%Time = t = 5…

Q: lion, with the first payment occurring immediately. money can earn 6% interest compounded annually…

A: in this we have to calculate present value of both option and see which option give better value.

Q: Ed wants to have $30,000 in 20 years. He opens a savings account in a bank which pays 7.2% interest…

A: Interest - The sum that the borrower pays to the lender above the principal amount and is fixed at a…

Q: Ms. Keto invested $500 per year for 10 years and received $12,000 at the end of the 10th year. Find…

A: Yearly investment = pmt = $500Payment at end of 10 years = FV = $12,000No of years = nper = 10

Q: 9 Six months after graduation from college, Jennifer decided to start a savings account for graduate…

A: Effective annual return is the rate of return which will consider the effect of frequency of…

Q: help please answer in text form with proper workings and explanation for each and every part and…

A: Step 1:Present value of annuity = Annual amount * PVA(Rate , years).Step 2:Step 3: Step 4:

Q: How long will it take PhP15,000 to earn PhP5,000 if it is invested at 12% monthly?

A: The total number of compounding periods can be calculated using the NPER Function in excel. The…

Q: You have decided to start saving for retirement. You plan to work for 35 years and then retire.…

A: Retirement planning is a means of planning to achieve financial independence in the future and to…

Q: , how much would he have to invest to have

A: This calculation is based on the compound interest formula, which takes into account the fact that…

Q: GROWTH: Uncle Hudsen puts $1000 into an account for his nephew when he is born. The account will…

A: Compound Interest is method of computing interest where compounding is done. Compounding refers to…

Q: Ken starts saving for down payment on a house that he plans to buy 5 years from now. He plans to…

A: The idea of the temporal value of money (TVM) holds that a quantity of currency is valued currently…

Q: Your cousin is currently 9 years old. She will be going to college in 9 years. Your aunt and uncle…

A: STEP 1 Present Value Given a certain rate of return, present value (PV) is the current value of a…

Q: Suppose you wish to retire 40 years from today you determine you need $50,000 per year once you…

A: Given: Payment = $50,000 Interest rate = 6% Retirement years = 25 Retire in = 40

Q: Question Help ▼ You plan to deposit $800 in a bank account now and $500 at the end of the year, If…

A: given, rate =3% year cashflow 0 $800 1 $500 future value formula: future value =present…

Q: Pamela is also a saver. She sets aside $100 per month during her 40 year career. She invests in the…

A: Hi There, thanks for posting the question. But as per Q&A guidelines, we must answer the first…

Q: To help with a down payment on a home, Rita is going to invest. Assuming an interest rate of 1.67%…

A: Present value, also known as present discounted value, is a financial concept that refers to the…

Q: Alec, Daniel, William, and Stephen decide today to save for retirement. Each person wants to retire…

A: Future value (FV) is a financial concept that represents the value of an investment or a sum of…

Q: in text form with proper workings and explanation for each and every part and steps with concept and…

A: Given:Future value = $2.4 milliont = 25 yearsr = 6% or 0.06 Solution:a). - To determine the amount…

Q: You buy a home when you are 25 years old, $200,000 principal, 2.75% for 15 years. When the home is…

A: Data given: Loan amount=$200,000 n=15 years Rate=2.75%   Working Note#1 Calculation of nper nper=15…