You need $34877 in 6 years.  If you think you could earn an annual rate of 11.77%, what would be your required monthly deposit to meet your goal?  (Remember that you need a monthly "r" and a monthly "t".) Answer:

Q: .You a buying a home for $425,000 and would like to determine the monthly mortgage payment. You can…

A: The excel formula to calculate the monthly payment is - Monthly payment = PMT (Interest…

Q: a) How much is in your account on retirement? b) Suppose you set up your account as a perpetuity on…

A: “Since you have posted a question with multiple subparts, we will solve the first three subparts for…

Q: year, to make a down payment of $75,752 on a vacation home If you can earn 3.03 percent on your…

A: The future value idea is a useful tool for investors to compare various investment prospects.…

Q: You want to borrow $25,000 to buy a new car. Your annual interest rate is 6.2% over 4 years with…

A: Given: Loan borrowed = $25,000 Interest rate = 6.2% years = 4

Q: You have already saved $6975 to buy a used car. You invest this money in a certificate of deposit…

A: Future Value refers to the value of the current asset at any specified future date for a given…

Q: You would like to have ​$   59,000 in   15 years.  To accumulate this​ amount, you plan to…

A: The concept of time value of money tells us that worth of money keeps on changing with passage of…

Q: Assume you would like to have $500,000 by the time you reach retirement. Assume a 5% interest rate…

A: Here, Future Value (FV) is $500,000 Interest Rate (Rate) is 5% Time Period (Nper) is 20 years…

Q: You want to buy a $255,000 home. You plan to pay 5% as a down payment, and take out a 30 year loan…

A: Amount of home = $255,000 Down payment = 5%  The time duration of the loan = 30 years

Q: you want to buy a car for $8300 with $360 monthly payments for 4 years, what is the annual interest…

A: Interest rate is the rate which the customer would have to pay on the periodic payment of the…

Q: You want to buy a $260,000 home. You plan to pay 5% as a down payment, and take out a 30 year loan…

A: a) Loan Amount = Total price of house - Down payment  = 260,000 - (260,000 * 5%) = 260,000 - 13,000…

Q: need $20,000 five years from now. The account pays 9% compounded annually. If you will receive…

A: Present value is the equivalent value today of the future cash flow based on the time and interest…

Q: You would like to have $800,000 when you retire in 30 years. How much should you invest each quarter…

A: Amount required (FV) = $800,000 Quarterly interest rate (r) = 0.005 (i.e. 0.02 / 4) Number of…

Q: How much should you deposit at the end of each month into an investment account that pays 8.5%…

A: Retirement income is the money one receives after they stop working, either through savings,…

Q: You have decided you would like to deposit $5,000 into your account today and not touch it until you…

A: Future value of amount is the value of today money in future based on time and interest and is equal…

Q: How much interest will you earn?

A: The time value of money recognizes the idea that the value of an amount of money today differs from…

Q: (Comprehensive problem) You would like to have $59,000 in 15 years. To accumulate this amount, you…

A: Annuity is the series of equal cash payments over the period.

Q: You've been offered a loan of $10000, which you will have to repay in 10 equal annual payments of…

A: We take loans to buy large ticket items like a car or a house or to fund high expenses like college…

Q: suppose you start saving today for a 40000 down payment that you plan to make on a house in 8 years.…

A: Present Value is the current value of all the cash flows which is to be received in the future which…

Q: ou want to borrow $27,000 from your local bank to buy a new car. you can afford to make monthly…

A: The given problem can be solved using RATE function in excel. RATE function computes interest rate…

Q: Suppose you want to have $400,000 for retirement in 30 years. Your account earns 5% interest. How…

A: Computation as follows: Hence, each month deposit will be $480.62.

Q: You estimate that you will have $30,000 in student loans by the time you graduate. The interest rate…

A: Amount of the student loan =$30000The interest rate compounded monthly =5%Number of years of loan…

Q: You are going to buy a house and borrow $542474 with a 30-year mortgage.  Your interest rate is…

A: The future value concept is widely used in finance and economics, including in the areas of…

Q: You want to buy a $248,000 home. You plan to pay 5% as a down payment, and take out a 30 year loan…

A: Loan: It represents the amount borrowed by the borrower for the purpose of purchasing assets like…

Q: Suppose you want to have $400,000 for retirement in 20 years. Your account earns 5.1% interest. How…

A: Future value required (FV) = $400,000 Interest rate = 5.1% Monthly interest rate (r) = 5.1%/12 =…

Q: You need to have $25000 for a down payment on a house in 5 years. If you can earn an annual interest…

A: Concept is of present value. Present value is the current value of a future cash flow at a specified…

Q: You would like to purchase a car that costs $47000 at 7% APR for 3 years. What is your monthly…

A: Cost (PV) = $47000 Interest rate = 7% Monthly interest rate (r) = 7%/12 = 0.583333333333333% Period…

Q: At your new job, you will be making monthly deposits of  $285 into a 401k.  If you think that you…

A: Data given: Monthly deposit=$285 N=6 years Rate=13.57%   Required: Amount in 6 years

Q: Use Excel to answer this question: You want to borrow money from your bank to purchase a car. The…

A: Amount you can borrow = Present value of the maximum monthly paymentsNOTE :here the monthly payment…

Q: You want to buy a $226,000 home. You plan to pay 5% as a down payment, and take out a 30-year loan…

A: Price = $226000 Down payment = 5% Interest rate = 6.55% Monthly interest rate (r) = 6.55%/12 =…

Q: Suppose you have a student loan of $35,000 with an APR of 6% for 40 years. Comp parts (a) through…

A: When the lender lends a loan to the borrower, he charges a rate of interest on the borrowed amount.…

Q: Suppose someone needs dollars 8969 in his account 5 years from now and the required rate of return…

A: Amount - 8969 Time - 5 years Rate of return - 0.1 per year compounded continuously

Q: You wish to purchase a home for $500,000. You will make payments of $30,000 at the end of every year…

A: The present value of an annuity is the value today of a series of equal payments that are made at…

Q: Suppose that you'd like to retire in 40 years and you want to have a future value of $ 800000 in a…

A: Compound = monthly = 12 Time = t = 40 * 12 = 480 Future value = fv = $800,000