Your friend is currently paying $734 in rent monthly in Fort Wayne and would rather apply the payment toward purchasing a home. If she can get a 30 year mortgage at 4.67% APR using her current payment amount, how much could she borrow?  What could you type into Excel to calculate this value?

Bha

不 Claire needs to borrow $5000 to pay for NHL season tickets for her family. She can borrow from a finance company (at 2.78% add on interest for 5 years) or she can borrow from credit union (60 monthly payments of $03 78 each). Find the APR for each loan using a TVM solver, and decide which one is Claire's better choice The APR for the finance company loan is (Type an integer or decimal rounded to the nearest hundredth as needed)

A landlord needs to update a rental house due to it's age, so it can be habitable again. If he has that ability to cover a $1,200.00 payment monthly for 3 years at 3% compounded monthly, how much can he borrow and still be able to afford the payment?   He can borrow $. (Round to 2 decimal places.)

If Sam can afford payments at $390 per month for 6years. what is the price of a car that she can afford now? Assume an interest rate of 6.6 percent.

In the Excel Payment Function file that follows, you are looking to see what your basic mortgage payment will be if you buy a home for $250,000.  It will be  a 30-year mortgage. The interest your bank will charge will be 7.5%.  In cell C5, use the PMT function to determine what your monthly payment will be.  Submit the spreadsheet in Canvas.

Please build an excel spreadsheet and show the formulas  to answer a. through g. using the information below You bought a house with price of $250,000. Your LTV (loan-to-value ratio) is 80%. You choose the 30-year mortgage with interest rate 6%. Assuming the total transaction cost is $10,000. a. What is your loan amount? b. What is your monthly payment? c. What will be the loan balance at the end of nine years? d. What is the effective borrowing cost if the loan will be prepaid at the end of nine years? e. In the monthly payment, how much you pay for the principle and how much you pay for the interest in the 1st and the 2nd month? f. What will be your interest payments for the first 5 years (year 1 to year 5) and the last 5 years (year 26 to year 30)? g. What is your annual percentage rate (APR)?

If this family of 4 wants to save up for a vacation in 2 years, how much should they deposit each month into a savings account earning 1.85% annual interest? iF THEY HAVE TO SAVE UP $4580 (Round your answer to the nearest DOLLAR and type it without any commas, dollar signs, ect)   If instead they decide to take the vacation now and put it on a credit card, how much would they need to pay each month to cover the cost of this credit card charge after 2 years if their credit card charges an APR of 19% (which is the average APR for new credit cards currently)?   (Round your answer to the nearest DOLLAR and type it without any commas, dollar signs, ect) $ How much more will this family pay for their vacation using their credit card instead of saving?

Please provide answer to part b of the question. Please answer by using formula, not excel.

You want to buy a new house.  You can afford to pay $15,000 per year for 30 years with the first payment being due one year from today.  If the interest rate on your loan is 3%, what price of home can you buy today? Enter your answer as a number rounded to 2 decimal places.