Purchase Solution

House purchase: compute settlement statement, amortization

Not what you're looking for?

Ask Custom Question

What I believe to be irrelevant information: making $42, 000/yr; minimum of 10% down on actual selling price; home insurance $1000/yr & property taxes $3100/yr paid separately from loan; payments will start one month from the time of purchase; no points.

What I believe to be relevant information: asking price $139, 000; 15% discount; 50% off of 6% real estate agent fees; real estate agent fees are 3% of selling price; title insurance is 1/2 of 1% of selling price; surveying fees $350; legal fees $500; document fees $250; miscellaneous fees $150; loan origination fee 1% of all money borrowed except origination fee. Borrowing remaining amount above down payment at a stated nominal loan rate of 6.5%. 30 year loan.

I have to determine the total amount that I will need to borrow (everything but the down payment; do include origination fee as well.) Determine the monthly payment. Determine the amount of taxable interest I will pay in the 1st, 5th and 15th years. How much interest will I pay total? What is the total dollar amount I will pay? Set up an amortization schedule listing the monthly payments, the interest paid, the principal paid, and the loan balance for the entire 360 month period.

I used bankrate.com, which I am allowed to do. I attached the amortization schedule to my problem.
So far I have: the asking price: 139000 - 15% discount: 20850 = the selling price: 118150
The real estate agent fee is 3% of selling price: 118150 = 3544.50. Title insurance is 1/2 of 1% of 118150 = 590.75. So the total amount to borrow would be: selling price: 118150 + real estate agent fee: 3544.5 + title insurance:590.75 + surveying fees: 350 + legal fees: 500 + document fees: 250 + Misc. fees: 150 = 123,035.25 + origination fee:(1% of all money borrowed except for the origination fee) 1230.35 = total amount to borrow = 124, 265.60. According to the attached amortization schedule, my monthly payment would be $785.44. Taxable interest for 1st year: $8036.37; 5th year: $39, 187.23; 15th year: $107,280. 21. By 2036 I will pay $158, 493.92 total interest. The total dollar amount I will end up paying is: total interest $158493.92 + Principal Paid $781.21 = $159275.13.

The attached amortization schedule gives me: the montly payments, the interest paid, the principal paid, and the loan balance for the entire 360 month period.

I want to know if these numbers are correct.

Attachments
Purchase this Solution
Solution Summary

In the solution, the work done by a student was carefully reviewed. There are some changes to correct the chain of data.

Solution Preview

I have reviewed your calculations and have three comments:

1. The amount you calculated at $123,035.24 is $500 light. I think it was simply an adding error because I agree with ...

Purchase this Solution
Free BrainMass Quizzes
Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Introduction to Finance

This quiz test introductory finance topics.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Operations Management

This quiz tests a student's knowledge about Operations Management

View More Free Quizzes
Related BrainMass Solutions

  • Mini-Project 1: Mortgage Loan Analysis

    Smith plan to buy a house in Los Angeles in October, 2010. The purchase price of the house is $580,000. They plan to pay 20% down payment and borrow the remaining 80% from ABC Bank with a 15-year, 4% fixed-rate mortgage loan.

  • Computation of Pension Expense

    Plan assets at January 1, 2005 640,000 Projected benefit obligation at January 1, 2005 800,000 Unrecognized prior service cost balance at January 1, 2005 150,000 Interest/discount (settlement) rate 10% Compute the pension expense for

  • Pension expense and Journal entries

    Cost $60000 Actual and expected return on plan assets $24000 Amortization of prior service cost $10000 Contributions (Funding) $115000 Accumulated benefits obligation 12/31 $500000 Interest/Settlement rate 9% 2010 Plan assets (FV) 12/31

  • Comprehensive Pension Plan Problem

    Instructions: (Please show step by step instruction on how to compute each of the following completely) (a) Determine the pension expense to be reported on the income statement for 2011. (Round all computations to nearest dollar.)

  • Long Term Liabilities- Entries for Bond Transactions

    (b) How should Strickland report the gain or loss on the disposition of machine and on restructuring of debt in its 2012 income statement?

  • Income Tax Payable, Pension Expense, Return on Plan Assets..

    Prepare Garfield's journal entries for (a) the purchase of the investment and (b) the receipt of annual interest and discount amortization. Assume effective interest amortization is used. (Round answers to zero decimal places, e.g. 25,000.

  • Pension calculation

    rate used in actuarial computation 10% Expected return on plant assets 9% Amortization of PSC (due to benefit increase) 100,000 Amortization of net gains

  • Howell Auto Parts: Lease vs buy

    Compute the annual payment for the loan. c.Compute the amortization schedule for the loan. d. Determine the depreciation schedule. e. Compute the after tax cost of borrow-purchase alternative.

  • Schedule A Real Estate Deductions for the Sale of a Home

    The apportionment to the buyer and seller would be shown in the respective amounts on the closing settlement statement (also called a HUD statement).

View More Related Solutions