Please Use an excel spreadsheet and show all of the steps to solve the following Please: You buy a house of $450,000 today. You put a down payment of 20% and borrow a fixed-rate mortgage of $360,000 with interest rate of 4% and 15 years. After 3 years, your house is appreciated to the value of $550,000 and market interest rate goes up to 6.5%. How much money will you make in book after 3 years?

Q: Suppose you are buying your first condo for $250,000, and you will make a $7,500 down payment. You…

A: Monthly Payment  = P * r * [(1+ r)n/({1 + r}n -1)] Where, P = Principal borrowed =Asset value -…

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

A: When a person does not have enough money to buy any assets, he would consider taking a loan. The…

Q: You want to buy a $33,000 car. The company is offering a 5% interest rate for 5 years. What will…

A: The calculation of a loan's monthly payment is the subject of the topic. This is a typical financial…

Q: How much will you have after 5 years? How much will you have after 5 years if you make the deposits…

A: Each year Deposit RM 2500 Interest Rate 4%

Q: You can afford a $1300 per month mortgage payment. You've found a 30 year loan at 8% interest. a)…

A: Monthly payment (P) = $1300 Period = 30 Years Number of monthly paymenst (n) = 30*12 = 360 Interest…

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 have a 30-Year mortgage loan for $300,000 with an interest rate of 6%  If you want to pay off…

A: Mortgage refers to the loan availed against the purchase of the real estate. Mortgage repayment…

Q: You can afford a $850 per month mortgage payment. You've found a 30 year loan at 8% interest. a) How…

A: The present value function or concept can be used to determine the present value of a future sum or…

Q: Suppose you want to purchase a home for $425,000 with a 30-year mortgage at 5.74% interest. Suppose…

A: Home cost = $425,000Period = 30 yearsInterest rate = 5.74%Down payment = 30%

Q: Want to be able to withdraw $50,000 each year for 30 years. Your account ea a) How much do you need…

A: Present value is the equivalent value today needed based on the time and interest rate of the money…

Q: Suppose you found the house that you have been looking for years! It comes with a price tag of…

A: Price of house: $210,000Down payment: 10%Loan rate: 3.5%Loan period: 30 years

Q: sume that you plan to buy a condo 5 years from now and you need to save for a down payment. You plan…

A: solution given Annual deposit 2500 Interest rate 4% Number of years 5 years…

Q: You bought a house with a $378016 mortgage that you will pay off over 26 years.  Given your credit…

A: When buying big ticket items like a house we do not have the financial capability to pay for the…

Q: ou just borrowed $490,000 for a mortgage on your new home. The mortgage has a 30​-year term with…

A: Mortgage loans make home buying home easy because paid by easy monthly payments that carry payment…

Q: If you want to buy a car, and you can afford a monthly payment of $425, how large of a loan can you…

A: Using excel PV function to get the loan amount

Q: You are offered the opportunity to put some money away for retirement. You will receive 10 annual…

A: The following information has been provided,10 annual payments of $5,000 beginning in 26 years will…

Q: Calculate your monthly payment. Round your answer to the nearest cent.

A: Loan Payments: These are payments made by the borrower to amortize the loan value. This is done by…

Q: a) How big of a loan can you afford? b) How much total money will you pay the loan company? c) How…

A: Loan is financial agreement where a person (lender) lends lump-sum money to other person (borrower)…

Q: Solve the problem with complete solution. 10. You purchase a house and lot for 1,850,000 and obtain…

A: The equivalent cost is the periodic payment made towards the acquisition of an asset or security for…

Q: If you lend $3000 to a friend for 15 months at 8% annual simple interest, find the future value of…

A: Futre value of loan is calculated as follws:-FV= A+IwhereFV= future value of loanA= Amount of loan I…

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

A: Retirement amount = $400,000Number of years = 25Interest rate = 5%To find: a) Monthly deposit, b)…

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: If you would like to accumulate $4,200 over the next 6 years when the interest rate is 8%, how much…

A: PV=FV/(1+i)^n (PV= present value FV= Future value i= discount rate  n= Number of period ) FV=…

Q: When you purchased your house, you took out a 30-year mortgage with an interest rate of 4.8% per…

A: The entire amount needed to fully satisfy a debt or other financial obligation is called the payoff…

Q: Suppose you are buying your first condo for $190,000, and you will make a $10,000 down payment. You…

A: Monthly payments refer to the amount that is being in every month including the principal and…

Q: You have just taken out a five-year loan from a bank to buy an engagement ring. The ring costs…

A: correct answer is option a)   year 0 year 1 year 2 year 3 year 4 year 5               cash…

Q: Give typing answer with explanation and conclusion you want to borrow $71,400 from your local bank…

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

Q: You wish to buy a house. The market value of the house is $650,000 and you have saved $120,000 as a…

A: Interest Rate = 6.5% Time Period = 26 Years Market Value = $650,000 Down Payment = $120,000

Q: Suppose you are buying your first home for $144,000, and you have $17,000 for your down payment. You…

A: purchasing price = $144,000 down payment = $17,000 loan amount = $144,000 - 17,000…

Q: You can afford an $800 per month mortgage payment. You found a 30-year loan at 6% interest. How big…

A: a) Following information are given in the question:

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

A: A loan is a facility provided by a lender to the borrower under which the borrower can take a lump…

Q: You take out a 30-year mortgage for $70,000 at 9.45%, to be paid off monthly. Construct an…

A: First we need to determine the monthly payment using the formula below: Monthly payment = loan…

Q: Please build an excel spreadsheet and show the formulas  to answer a. through g. using the…

A: See the answer in the explanation field.Explanation:Answer information:Step 1:a) Loan Amount = Price…

Q: You want to buy a new house.  You can afford to pay $15,000 per year for 30 years with the first…

A: Annual payment (A) = $15000 n = 30 years r = 3%

Q: nt a.)If his new home costs $136,000, what is his down payment? b.)How much is he going to borrow…

A: PMT function computes installment amount for given interest rate (RATE), no. of installments (NPER)…

Q: you want to purchase a home for $475,000 with a 30-year mortgage at 5.84% interest. Suppose also…

A: Mortgage loans are paid by equal monthly installments and these monthly payment carry the payment of…