Question

In: Accounting

Jasmine and her husband are considering trading up their home by selling their current house and...

  1. Jasmine and her husband are considering trading up their home by selling their current house and buying a new house at a price of $250,000. They plan to sell their current house for $120,000 and use the money for a down payment. They will take out a mortgage to cover the remaining balance. The interest rate for such a mortgage amortized over a 20-year period is 7.75%, compounded monthly. (Note that the Canadian mortgages are calculated differently than other types of loans. Here we will treat it like a loan. If you take Fin2360, you will see how to make adjustments for the Canadian mortgage law).
    1. What will Jasmine’s monthly mortgage loan payment be?
    2. What will be the total interest that Jasmine and her husband will pay over the 20-year life of the loan?
    3. How much of her 1st payment is towards interest, and how much is applied against the principal of the mortgage loan?
    4. Use Excel to construct an amortization table for the first 3 payments, and print out the table with your name and ID.   You can also do this by hand.
    5. How much does she still owe after making five years of payment?
    6. How much of the 61st payment is towards interest, and how much is applied against the principal of the mortgage loan?

Solutions

Expert Solution


Related Solutions

Jasmine and her husband are considering trading up their home by selling their current house and...
Jasmine and her husband are considering trading up their home by selling their current house and buying a new house at a price of $250,000. They plan to sell their current house for $120,000 and use the money for a down payment. They will take out a mortgage to cover the remaining balance. The interest rate for such a mortgage amortized over a 20-year period is 7.75%, compounded monthly. (Note that the Canadian mortgages are calculated differently than other types...
Jasmine and her spouse are considering purchasing a larger house for their growing family. Below is...
Jasmine and her spouse are considering purchasing a larger house for their growing family. Below is a summary of their current combined income and expenses. Combined Salary (Net Annually) $97,500 Monthly Mortgage Payment $1,200 Master Card (minimum monthly payment) $1,000 Utilities (Heath and Electricity) $150 Car Loan Payment $850 Cable TV $50 Cell-Phone Plan $100 Line of Credit (minimum monthly payment) $200 Property Tax (annual) $2,000 Question 13 (1 point) What is Jasmine's family average monthly income? (1 mark) Question...
Mrs. Tolstoy and her husband, Serge, are planning their dream house. The lot for the house...
Mrs. Tolstoy and her husband, Serge, are planning their dream house. The lot for the house sits high on a hill with a beautiful view of the Appalachian Mountains. The plans for the house show the size of the house to be 2,900 square feet. The average price for a lot and house similar to this one has been $120 per square foot. Fortunately, Serge is a retired plumber and feels he can save money by installing the plumbing himself....
Yasmin divorced her husband in 2018. In 2019, she maintains a home in which he and...
Yasmin divorced her husband in 2018. In 2019, she maintains a home in which he and her 10-year-old son live. Her ex-husband pays child support to her that she uses to provide all of the support for the child. Who is entitled to claim the child as a dependent? Explain whether each test has been met or not.
I am considering selling my current home through an ownerfinanced arrangement. I have beenoffered...
I am considering selling my current home through an owner financed arrangement. I have beenoffered $1,000 per month for 20 years with the first payment due immediately plus anadditional $100,000 with the last payment at the end of 20 years. If the appropriate discountrate is 6% APR compounded monthly, then what is the equivalent cash offer for my house?
Mrs. Brown is a 61 year old lady who lives at home with her husband. She...
Mrs. Brown is a 61 year old lady who lives at home with her husband. She has a history of hypertension that is controlled with medication. Mrs. Brown was walking through her home and tripped on the corner of one of her area rugs resulting in a fall with complaints of right hip pain. Her husband called an ambulance and Mrs. Brown was transferred to hospital. In the emergency department she was diagnosed with a minor pelvis fracture. She was...
Penny Lawrence is a research scientist in Miama, Florida. Her husband Lary Lawrence stays home to...
Penny Lawrence is a research scientist in Miama, Florida. Her husband Lary Lawrence stays home to take care of their two young children, George (age 11) and Allie (age 9). Penny's total wages for 2019 were $73,023 from which $6,418 of federal income tax was withheld.  Florida does not have a state income tax. They had $213 in interest income. Penny received dividends from Exxon in the amount of $434 and Lary received dividends from First National Bank in the amount...
You've saved up to buy a house and will put $60,000 down on a $350,000 home....
You've saved up to buy a house and will put $60,000 down on a $350,000 home. You're stated interest rate is 4.3%, and you'll make monthly payments for 30 years. What will be your mortgage payment?
Marina advertises her family home for sale on Trade Me anddescribes the house as being...
Marina advertises her family home for sale on Trade Me and describes the house as being “in the Grammar Zone”. Eric buys the house but subsequently discovers the house is not in the Grammar zone and his children will have to go to a different school. Which TWO statements best describe Eric's legal position:Eric may claim under s9 of the Fair Trading Act for misleading and deceptive conduct.Eric may claim under s13 of the Fair Trading Act for false or...
Allan set up a trading business, buying and selling goods. The following transactions took place in...
Allan set up a trading business, buying and selling goods. The following transactions took place in the first month of its trading, July 2020. Allan introduced $500,000 cash into the business bank account. The business bought a motor vehicle with price of $60,000. The payment was by cheque. The business bought some inventory for $30,000. The payment was by cheque. The entire inventory purchased in transaction #3 was sold $65,000 in cash. Additional inventory was purchased amounting to $100,000 on...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT