Please use excel if applicable
Susan wants to buy a house for $400,000. US Bank will give her the loan at 3% for 30 years if she puts 20% down and Dacotah Bank will give her the loan at 3.5% for 30 years if she puts 10% down. There are NO other options.
Which loan should she sign up for? Pick one, no explanation needed. What is her monthly payment?
After 5 years, Susan is approached by a philanthropic group known as C.S.C. They offer to lend her $80,000 interest free for an indefinite period of time, provided she joins their group. Susan takes up the offer and uses the money to pay off some of her mortgage. What will be her new NPER (how many years will it take for her to pay off her remaining mortgage)?
After another 7 years (12 years from start), a private bank offers to take over the remaining mortgage at 2.5%. What will be her first month interest payment if she signs up with them? (To do this, find the remaining mortgage after 12 years. Use this mortgage amount as the new principle. First month interest payment will be the monthly rate multiplied by principle).