You want to buy a house that costs $620,000. You can put $55,000 down. You get a 30 year fixed-rate loan with an APR of 4.5% compounded monthly. 104. Determine the monthly payment. Show clear work. Work: Work: Answer: Find the total closing costs if they consist of a fee of $1600 and 3 points. Answer: Suppose that you invest $4800 in an account with an APR of 6.9%, compounded continuously. Determine how much you will have after 3 years. Assume that no additional deposits are made.

← You need a loan of $150,000 to buy a home. Calculate your monthly payments and total closing costs for each choice below. Briefly discuss how you would decide between the two choices. Choice 1: 20-year fixed rate at 6% with closing costs of $2900 and no points. Choice 2: 20-year fixed rate at 5.5% with closing costs of $2900 and 4 points. What is the monthly payment for choice 1? A (Do not round until the final answer. Then round to the nearest cent as needed.)

Suppose that a car that you want costs $9000.  You make a down payment of $1000 and finance the rest for 4 years at 1.9% interest, compounded monthly.  If you make monthly payments for 4 years, what is the total amount of interest that you'll end up paying?  Round your answer to two decimal places if rounding is necessary.  The $ sign is already written next to the answer box, so do not type a $ sign in your answer.

You have saved $5,000 for a down payment on a new car. The largest monthly payment you can afford is $500. The loan will have an 11% APR based on end-of-month payments. a. What is the most expensive car you can afford if you finance it for 48 months? Do not round intermediate calculations. Round your answer to the nearest cent. b. What is the most expensive car you can afford if you finance it for 60 months? Do not round intermediate calculations. Round your answer to the nearest cent.

Suppose you want to buy a $140,000 home. You found a bank that offers a 30-year loan at 3.3% APR. What will be your monthly payment? (Round to the nearest cent.) $ How much would you end up paying the bank for the home after 30 years? (Round to the nearest cent.) $ Suppose you wanted to reduce the time of your loan to 25 years. What would be your new monthly payment? (Round to the nearest cent.) $ How much would you end up paying the bank for the home after 25 years? (Round to the nearest cent.) S How much did you save by reducing the time of your mortgage loan? (Round to the nearest cent.) S Search hp

You are looking to buy a car that costs $30,000.  Your payment is $400/month for 60 months.  If you want to know your interest rate on this loan, you can use Excel.  Excel returns a RATE of 0.70%.  What is your APR?     8.45%     2.75%     3.24%     0.70%

Calculate how much money a prospective homeowner would need for closing costs on a house that costs $190,000. Calculate based on a 15 percent down payment, 1.3 discount points on the loan, a 1.2 point origination fee, and $820 in other fees. The closing costs would be $. (Round to the nearest dollar.)

d You have decided to buy a car that costs $31,000. Since you do not have a big down payment, the lender offers you a loan with an APR of 6.27 percent compounded monthly for 7 years with the first monthly payment due today. What is the amount of your loan payment? Multiple Choice $294.91 $454.51 $456.89 $374.71 $293.38

Suppose you are in the market for a new car worth $18,000. You are offered a deal fo make a S1,800 down payment now and to pay the balance in equal end-of-month payments of $421.85 over a 48-month period. Consider the following situations:a.Instead of going through the dealer's financing, you want to make a down payment of $1,800 and take out an auto loan from a bank at 11.75% compounded monthly. What would be your monthly payment to pay off the loan in four years?b. If you were to accept the dealers offer, what would be the effective rate of interest per month charged by the dealer on your financing?

Please show me how to solve this in excel using an excel spreadsheet and please show the excel formulas! Thank You!   A house price of $100,000 can be financed with two loans below with monthly payments. The total origination cost associated with these two loans in the table attached is $3000. Alternatively, the borrower can borrow one loan in the amount of $90,000 with monthly payments and origination cost of $2,000. What should the interest rate be on the loan of $90,000 so that the borrower will be indifferent between these two choices?