Use the PMT function in Excel to compute the monthly payment on a home each month if you borrowed 770,000 at an annual interest rate 5.82% over 30 years, where the interest is compounded monthly. Fv and type are not necessary ignore them. Please I don’t have excel, I could really use the help.

Q: You would be borrowing $350,000 for a home loan at 3% interest, but you are given two options: pay…

A: The calculation is: The formulation image is:…

Q: Sam would like to use the PMT function in Excel to calculate the monthly payments on a car loan of…

A: There are two types of annuities, i.e., (i) annuity due and (ii) ordinary annuity. An annuity can be…

Q: How much would you have to deposit at the end of the year in an account that pays an interest rate…

A: Monthly Deposit: It is the deposit made by the person over the period to accumulate a sum of money.…

Q: You have taken out a loan of $32,000 to buy a new Saturn. The loan will be paid off in monthly…

A: A loan is an agreement between two parties where an amount is changed in return for the amount being…

Q: Use the PMT function in Excel to compute the monthly payment on a car each month if you borrowed…

A: Monthly payments is the annuity for given present value, interest rate and time period. Monthly…

Q: You want to buy a new sports coupe for $79,500, and the finance office at the dealership has quoted…

A: The car loan is a contract where car buyer is allowed to take delivery of car by making small…

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: the amount you need to save each month

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

Q: How much would you have to deposit at the end of the year in an account that pays an interest rate…

A: Information Provided: Term = 15 years Future value = $20,000 Interest rate = 7.6% compounded monthly

Q: at period of time could you pay back a loan of $3000 by making monthly payments of $110 if interest…

A: Loans are paid by the equal amount of monthly payments these payments carry the payment of principal…

Q: You need to pay off a car loan within the next two years. The payment will be $4,000 everymonth.…

A: Using excel PV function

Q: You wish to buy a $10,000 dining room set.  The furniture store offers you a three-year loan with an…

A: Given information: Present value or principal value is $10,000 Number of years of loan is 3 Interest…

Q: When you start your career, you decide to set aside $600 every month to deposit into an investment…

A: GIVEN, R=11% A=$600 N=25 M = 12 (MONTHLY COMPOUNDING)

Q: You just bought a used car for $11,000 with no down payment using dealer financing at 4% APR…

A: Price of the Car is $11,000 APR is 4% compounded monthly Monthly payment is $300   To Find:- Time…

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: You need a home loan of $95,000 after your down payment. How much will your monthly house payment be…

A: Loan amount (PV) = $95000 Interest rate = 6.25% Monthly interest rate (r) = 6.25%/12 =…

Q: You want to borrow $65,000 from your local bank to buy a new sailboat. You can afford to make…

A: APR or Annual Percentage Rate implies for interest rate applicable on borrowed amount for each year…

Q: What formula do I use for this problem. A breakdown would be great to see. A personal account…

A: Annuity refers to the long term investment issued by an insurance company which is basically made to…

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

A: APR: The annual interest rate that is charged to the borrowers is known as the annual percentage…

Q: Suppose you want to have $7,876 for a vacation in the future. What will be the estimated total you…

A: future value formula: future value = present value ×1+rateyear future value of annuity…

Q: How much money would you need to place in an account to have $1,000 10 years from today? Assume the…

A: The formula used as follows: Present value=Future value1+innt

Q: 12. You are ready to buy a house, and you have $20,000 for a down payment and closing costs. Closing…

A: As per the time value of money, a dollar is worth more today than the same dollar in the future.…

Q: IF you deposit $300 each quarter into an account earning 3.2% compunded quarterly, how many years…

A: Given that;Quarterly deposit amount (pmt) is $300Future value of the amount is $15,000Interest rate…

Q: Suppose Capital One is advertising a 60-month, 5.42% APR motorcycle loan. If you need to borrow…

A: EMI or monthly mortgage payments are the fixed amount paid by the borrower to the lender that…

Q: there is a house on sale for $800,000. You believe you can finance the home for $500,000 for 20…

A: In this we have to calculate present value FACTOR monthly and calculate the monthly payment.

Q: You want to take out a $450,000 loan on a 20-yearmortgage with end-of-month payments. The annualrate…

A: Repayment of mortgage is made in fixed amount of instalments which includes interest and part of…

Q: You have a balance of $5,000 on your credit card.  The interest rate is 15% per year.  You want to…

A: Balance in credit card = $5,000 Interest Rate(r) = 15%/12= 1.25% per month Years = 4 Terms(n) = 4*12…

Q: You buy a lathe for $10,000. You are charged an annual interest rate of 12% and pay equal quarterly…

A: Loan = 10,000 Interest rate = 12%/4 = 3% per quarter N = 20*4 = 80 Quarters

Q: You decide that you need $47,000 in 3 years to make a down payment on a house. You plan to make…

A: Since you have asked multiple questions, we will solve the first question for you. If you want any…

Q: You borrow $5000 now and agree to pay this whole amount back in three payments Poyment 1. SX in 2…

A: Discounting of money is the process of determining the present value of future cash flows. The…

Q: At the moment you don't have any money saved for retirement, but have resolved to start making $425…

A: Given, The amount of monthly payments is $425 Effective annual rate is 9.9% Amount to be accumulated…

Q: You purchase a home and secure a 30 year equal payment loan for $200,000 at a interest rate of 5.25%…

A: The number of months to stay will be around 6 months.

Q: If a dealer offers you a car at $275 monthly payment for 5 years plus $5,000 down. If you can get a…

A: Loan is an agreement between lender and borrower. Lender agrees to provide funds t borrower at…

Q: You want to buy a car and therefore you need $10,000. You can borrow from a bank today for 6 years.…

A: Purchase Price of Car = 10,000 Time Period (N) = 6 years i.e. 72 months Down Payment = 10% Loan =…

Q: You plan to purchase a $500,000 home with a 20% down payment. You can take out a 30-year FRM of…

A: Since you have posted a question with multiple sub-parts, we will solve first three subparts for…

Q: How much would your monthly payment be on a 3-year loan if the following assumptions were true? You…

A: In order to find the payment per month and the total amount paid to the bank, one has to use excel…

Q: You want to be able to withdraw $50,000 each year for 30 years. Your account earns 5% interest.…

A: This the question of present value of ANNUITY. Annuity is a equal stream of cashflow at equal…

Q: Suppose you want to save $220,000 for retirement. You will do so by putting monthly deposits into an…

A: Retirement planning involves the set of activities that determines the income goals that an…

Q: What is the monthly payment for a 5 year new car loan, when the nominal annual interest is 6%. After…

A: The time value of money becomes an important factor for capital budgeting decisions. It is an idea…

Q: You have just taken out a $25.000 car loan with a 4% APR, compounded monthly. The loan is for five…

A: A monthly mortgage payment is a monthly payment that is to be paid for a specific period of time to…

Q: Suppose that you borrow $10,000 for four years at 8% toward the purchase of a car. Use PMT to find…

A: given, p = 10000 n = 12 r =8% t= 4 pmt=p×rn1-1+rn-nt=10000×8%121-1+8%12-12×4=$244.14 MONTHLY PAYMENT…

Q: Suppose you found a CD that pays 2.9% interest compounded monthly for 6 years. If you deposit…

A: Deposit money (P) = $12000 Compound interest (r) = 2.9% compounded monthly  Time (nt) = 6 years =…

Q: At the moment you don't have any money saved for retirement, but have resolved to start making $425…

A: Given: Monthly payments "PMT" = $425 Effective annual rate = 9.9% Future value "FV" = $2400000

Q: You borrow $22541 to buy a car. You will have to repay this loan by making equal monthly payments…

A: In order to calculate the monthly payment on the financial calculator, firstly we are required to…

Q: You need a home loan of $65,000 after your down payment. How much will your monthly house payment be…

A: FORMULA Monthly payment = LV/[1-(1+R)-N]/R Where LV - Loan amount i.e. $65000 R - Monthly interest…

Q: You want to buy a car and you want your payments to be $500 per month.  You can finance the car for…

A: Equated monthly installment (EMI):   = [P×R×(1+R)n] ÷ [(1+R)n-1]