Please show how to solve this in Excel using Excel formulas and please show the spreadsheet so I can understand better. Suppose Cindy borrows $300,000 at 4% for 30 years, monthly payments. The APR on the loan is 4.25%. What amount of points were charged if there was $5,000 origination cost?

Answer the given question with a proper explanation and step-by-step solution. Please provide the answer using the math tool otherwise I give the downvote.

It does not have to be a long explanation.

Susan would like to buy a car. She went to the bank and got a loan for $40,000 at the annual interest rate of 4%, for 4 years. Calculate the monthly payment. Calculate the interest on the payment. Calculate the total payment. Make complete amortization schedule on excel

After starting your first full-time job out of college, you decide to buy a new car for $12,000. Using Excel, create a complete amortization table for this car-loan: You make 36 equal end- of-month payments. The discount rate is 7.25% compounded monthly. How much would you owe after the 15th payment is made? Use excel to solve

Typing only

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?

Solve each problem and round your answers to the hundredth decimal point 1. Stephanie is going to buy a car that costs $30,000. If she makes $650 a month payments for 48 months at 5.9% interest, how much was her down payment? 2. Fred is paying off a $24,000 loan over 4 years with $580 a month payments. If he will pay the entire loan off in that time, what is the interest rate? 3. How long will it take Gabriella to save $250,000 if she puts $475 a month into an annuity drawing 7.5% interest? 4.BCD Corporation is going to place $100,000 into an annuity. Then, it is going to add $25,000 a quarter to the annuity for the next 15 years. If the annuity draws 9% interest, how much will it be worth at the end of the time? 5. Karen decides to put the child-support payments from her previous husband into an annuity for the education of her two children. At the end of each month for 8 years, she puts $300 into a mutual fund that has yielded 9% compounded monthly. Find the amount of the annuity.

Help me with step by step answers on a TI 83, TVM solver and forumulas and timelines. You want to buy a car and need to see how big of a car loan you can afford. Your budget allows you allocate $289.99 per month for car loan payments. The bank will offer you a loan at 6% interest on an APR basis and monthly payments over five years. What is the amount of the loan you can afford? Use the $ symbol and round to the nearest dollar (no decimal places). Use commas in your answer if applicable.