I now have $30,000 in the bank earning interest of 0.75% per month. I need $40,000 to make a down payment on a house. I can save an additional $100 per month. How long will it take me to accumulate the $40,000?  Note: Do not round intermediate calculations. Round your answer to 2 decimal places. Use a financial calculator or Excel.

Q: For TVM calculator:  Write each known variable’s value as it appears in the calculator and use a…

A: Given information: Present Value : $1000 Interest rate : 4.9% Monthly payments : $170 Future value :…

Q: You are saving for a new house. You place $47,000 into an investment account at the end of each year…

A: Future value of annuity payment is the value of recurring payments at a future date considering a…

Q: For the given cash flows, suppose the firm uses the NPV decision rule. Year 0 1 2 3 Cash Flow -$…

A: NPV can be calculated by following function in excel=NPV(rate,value1,[value2],…) + Initial…

Q: Friendly's Quick Loans, Incorporated, offers you "$4.20 for $5.20 or I knock on your door." This…

A: The interest rate on a credit card or loan is commonly expressed as APR, or annual percentage rate.…

Q: Not use excel to solve Allison pays $27,506.28 for an annuity due today. This annuity will pay her…

A: The present value of annuity due is the present value of a series of cash payments that are expected…

Q: You have $480 to put into a savings account, and a bank offers you two options: Account A pays 3.1%…

A: Simple Interest is the method in which we calculate the interest on a specific principal amount at a…

Q: site, find another.) Type in a home price of $300,000. Leaving all other entries as they are, enter…

A: the monthly mortgage payments for the three interest rates using the formula for monthly mortgage…

Q: the amount you need to save each month

A: given   fv=25000 n= 5*12=60 interest i = 3.5% PMT =?

Q: You are saving for a new car. You place $15,400 into an investment account today. How much will you…

A: Present Value (PV) of amount invested = $15,400Interest rate (r) = 2%, 4%, 6% or 0.02, 0.04,…

Q: I now have $23,000 in the bank earning interest of 0.50% per month. I need $33,000 to make a down…

A: Future value of the amount is the amount being deposited and amount of interest accumulated on…

Q: You're trying to save to buy a new $195,000 Ferrari. You have $32,000 today that can be invested at…

A: Here, ParticularsValuesFuture value of money (FV) $1,95,000.00Present value (PV) $…

Q: Solve the following problems by showing your formula and computation: 1. what is the simple…

A: “Hey, since there are multiple questions posted, we will answer first question. If you want any…

Q: If you want to have $875 in 36 months, how much money must you put in a savings account today?…

A: Present value:Present value is a financial concept that refers to the current worth of a future cash…

Q: 10. Simple-interest loan $1800 @ 8% for 12 months with a monthly payment of $156.60. After 8 months…

A: Simple Interest is calculated as: = Principal * Rate * Time  Here, principal is the opening balance…

Q: Suppose you start saving today for a $50,000 down payment that you plan to make on a house in 5…

A: Down payment = $50,000Interest rate = 6% (Daily compounding)Number of years = 5 years

Q: nsider a situation in which you borrow 5000$. You will repay the loan in five equal ends of year…

A: Loans are paid by the equal periodic payments and these periodic payments carry payment for interest…

Q: You want to buy a car, and a local bank will lend you $40,000. The loan will be fully amortized over…

A: The monthly loan payment can be calculated by using the excel formula ''=PMT''Effective Annual Rate…

Q: How many months does it take to pay off the card, and what is the total amount paid including…

A: APR is the annual interest rate. It's like the annual fee for your borrowing. exist In other words,…

Q: If you have $10,000 that you want to save for 3 years, which of the following banks would you choose…

A: TVM refers to the capacity of money to earn interest because money earned earlier is considered more…

Q: Suppose you plan to start a saving account. You plan to deposit $98 each month in to a money market…

A: Compound = Monthly = 12Payment = p = $98Interest Rate = r = 6 / 12 = 0.5%Future Value = fv = $2000

Q: What is the effective interest rate per year?   What would you owe if you kept the money for 1…

A: First, I'm going to list the formula, and then solve them in excel. We need to determine the…

Q: You want to buy a nice road bike. You place $2,200 at the end of each year in an investment account…

A: The future value of an annuity is the total amount of money that will accumulate over a series of…

Q: Do a. an account that pays 2.3% every 6 months for 3 years? the relevant calculations so you can…

A: EAR stands for Effective Annual Rate, which represents the total amount of interest that would be…

Q: You saved 18,000$ for a down payment on a house. Your bank requires a down payment of 15%. What is…

A: Introduction: Down payment or mortgage installment refers to the periodic payment made against the…

Q: ou can earn .38 percent per month at your bank. If you deposit $2,100, how long must you wait until…

A: Future value of money is the amount that is deposited and amount of interest accumulated over the…

Q: You took out a loan that must be repaid with level payments at the end of each year. The loan has an…

A: Since you have posted multiple questions, we will provide the solution only to the first question as…

Q: You are saving to buy a $179,000 house. There are two banks in your area, both offering deposit…

A: To solve this problem, we need to calculate the time it takes for your initial $96,000 investment to…

Q: I now have $24,000 in the bank earning interest of .75% per month. I need $34,000 to make a down…

A: Down payment is a payment made for a purchase in its early stage.

Q: Write each known variable’s value as it appears in the calculator and use a question mark for the…

A: Annuity means finite no. of payment which are same in size and made in equal intervals for the…

Q: Suppose you have saved $216 each month for the last 7 years to make a down payment on a house. The…

A: The objective of the question is to calculate the total amount in the savings account after 7 years…

Q: Please show how to solve this in excel and please show the spreadsheet and formulas. Suppose that…

A: Loans are paid by equal monthly payments that carry the payment for interest and payment for loan…

Q: You borrowed $18,000 from a friend and promised to pay the loan in 12 equal annual installments…

A: To calculate the annual payment for an installment loan, you can use the formula for the present…

Q: Help

A: Step 1:  Step 2: Step 3: Step 4:

Q: You have a balance of $12,000 for your tuition on your American Express credit card. Assume that you…

A: Minimum payment refers to the amount that remains at the end of each month for maintaining the…

Q: You want to buy a car, and a local bank will lend you $15,000. The loan would be fully amortized…

A: The time value of money (TVM) is a concept in finance that refers to the idea that money available…