You decide to purchase the rental property from Project 1. Use the provided Excel template to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You decide to purchase the rental property from Project 1. Use the provided Excel template to perform the following tasks: 1. On the Amortization tab of the spreadsheet, calculate your down payment, your monthly payment and create a loan amortization table for the life of the loan. Review to the loan amortization tutorial in D2L. Note the total interest you paid at the bottom of the table. You must show your work by using formulas in Excel. 2. On the Closing tab of the spreadsheet, complete the Buyer's and Sellers' closing statements based on the following data: ● ● ● ● ● ● ● ● On June 15, Wilbur and Wilma Wildcat ("Sellers") listed their Flagstaff rental property for $285,000 with Re/Max Peak Properties and agreed to pay a 6% commission on the sale price. They have a mortgage for $140,000 remaining on the home. You offered $270,000 and Wilbur and Wilma accepted the offer. At that time, you put down $1,000 of earnest money. You will put 20% down and finance the rest through Bear Down Bank with a 15-year mortgage at a fixed rate of 4.75%. The sale will close on July 1st at which time you will take possession. Bear Down requires a loan origination fee of 1% of the value of the loan along with a property appraisal which will cost $400 and a credit report at a cost of $25. Property taxes for the current year were $1,264 and were paid in full by the Sellers. The Buyer's title insurance policy will cost $800, and the Sellers' title insurance policy will be $1,690. Homeowner's insurance will cost the Buyer $1,586. Recording the deed will cost $50 (equally split between the Buyer and Sellers). Endorsements of $150 would be paid by the Buyer. Courier fees will be $25 for the Buyer and $25 for the Sellers. All prorations are based on a 30-day month. Calculate the costs to the Buyer and the Sellers as a percentage of the purchase/sales price. 1) Use the data provided in the case description to complete the Buyer's and Sellers' Closing Statements below: 5 6 Summary of Buyer's Transaction Summary of Sellers' Transaction 7 Description Contract Purchase Price 8 9 10 Settlement Charges 11 12 13 14 15 16 Items Payable in Connection with a Loan Loan Origination Fee Appraisal Fee Homeowner's Insurance Credit Report Title Charges Title Service and Title Insurance Deed Preparation 17 18 19 20 21 Government Recording Charges: 22 Endorsements 23 Courier Fees 24 25 Gross Amount Due from Borrower 26 27 Amounts Paid by or on Behalf of Borrower 28 Deposit of Earnest Money 29 Principal Amount of New Loan 30 31 32 33 34 35 36 Gross Amount Due from Borrower Adjustments for Items OverPaid by Seller Property Taxes * Total Paid by the Borrower 37 Less: Total Paid by the Borrower 38 Cash at Settlement from Borrower 39 40 Total Expenses 41 Purchase Price 42 Expenses as % of Price 43 Cash 270,000.00 400.00 1,586.00 25.00 800.00 25.00 150.00 25.00 Description Contract Purchase Price Gross Amount Due to Seller Reductions in Amount Due Seller Brokerage Commission Payoff of Mortgage Loan Title Charges Title Service and Title Insurance Deed Preparation Government Recording Charges: Courier Fees Adjustments for Items OverPaid by Seller Propery Taxes Total Reductions in Amount Due Seller Gross Amount Due to Seller Less Reductions in Amount Due Seller Cash at Settlement to Seller Total Expenses Purchase Price Expenses as % of Price Cash 140,000.00 25.00 25.00 1,264.00 *As the closing date does not often coincide with the due date for property taxes, a portion of the annual property taxes is usually 44 prorated between the buyer and the seller. In this case, the full year of taxes was paid by the seller on January 1st. They owned the 45 home for only half of the year, so 50% of the taxes must be returned to the seller from the buyer. 46 You decide to purchase the rental property from Project 1. Use the provided Excel template to perform the following tasks: 1. On the Amortization tab of the spreadsheet, calculate your down payment, your monthly payment and create a loan amortization table for the life of the loan. Review to the loan amortization tutorial in D2L. Note the total interest you paid at the bottom of the table. You must show your work by using formulas in Excel. 2. On the Closing tab of the spreadsheet, complete the Buyer's and Sellers' closing statements based on the following data: ● ● ● ● ● ● ● ● On June 15, Wilbur and Wilma Wildcat ("Sellers") listed their Flagstaff rental property for $285,000 with Re/Max Peak Properties and agreed to pay a 6% commission on the sale price. They have a mortgage for $140,000 remaining on the home. You offered $270,000 and Wilbur and Wilma accepted the offer. At that time, you put down $1,000 of earnest money. You will put 20% down and finance the rest through Bear Down Bank with a 15-year mortgage at a fixed rate of 4.75%. The sale will close on July 1st at which time you will take possession. Bear Down requires a loan origination fee of 1% of the value of the loan along with a property appraisal which will cost $400 and a credit report at a cost of $25. Property taxes for the current year were $1,264 and were paid in full by the Sellers. The Buyer's title insurance policy will cost $800, and the Sellers' title insurance policy will be $1,690. Homeowner's insurance will cost the Buyer $1,586. Recording the deed will cost $50 (equally split between the Buyer and Sellers). Endorsements of $150 would be paid by the Buyer. Courier fees will be $25 for the Buyer and $25 for the Sellers. All prorations are based on a 30-day month. Calculate the costs to the Buyer and the Sellers as a percentage of the purchase/sales price. 1) Use the data provided in the case description to complete the Buyer's and Sellers' Closing Statements below: 5 6 Summary of Buyer's Transaction Summary of Sellers' Transaction 7 Description Contract Purchase Price 8 9 10 Settlement Charges 11 12 13 14 15 16 Items Payable in Connection with a Loan Loan Origination Fee Appraisal Fee Homeowner's Insurance Credit Report Title Charges Title Service and Title Insurance Deed Preparation 17 18 19 20 21 Government Recording Charges: 22 Endorsements 23 Courier Fees 24 25 Gross Amount Due from Borrower 26 27 Amounts Paid by or on Behalf of Borrower 28 Deposit of Earnest Money 29 Principal Amount of New Loan 30 31 32 33 34 35 36 Gross Amount Due from Borrower Adjustments for Items OverPaid by Seller Property Taxes * Total Paid by the Borrower 37 Less: Total Paid by the Borrower 38 Cash at Settlement from Borrower 39 40 Total Expenses 41 Purchase Price 42 Expenses as % of Price 43 Cash 270,000.00 400.00 1,586.00 25.00 800.00 25.00 150.00 25.00 Description Contract Purchase Price Gross Amount Due to Seller Reductions in Amount Due Seller Brokerage Commission Payoff of Mortgage Loan Title Charges Title Service and Title Insurance Deed Preparation Government Recording Charges: Courier Fees Adjustments for Items OverPaid by Seller Propery Taxes Total Reductions in Amount Due Seller Gross Amount Due to Seller Less Reductions in Amount Due Seller Cash at Settlement to Seller Total Expenses Purchase Price Expenses as % of Price Cash 140,000.00 25.00 25.00 1,264.00 *As the closing date does not often coincide with the due date for property taxes, a portion of the annual property taxes is usually 44 prorated between the buyer and the seller. In this case, the full year of taxes was paid by the seller on January 1st. They owned the 45 home for only half of the year, so 50% of the taxes must be returned to the seller from the buyer. 46
Expert Answer:
Answer rating: 100% (QA)
Sellers Closing Statement Description Amount Contract Purchase Price 27000000 Brokerage Commissi... View the full answer
Related Book For
Business Law The Ethical Global and E-Commerce Environment
ISBN: 978-0071317658
15th edition
Authors: Jane Mallor, James Barnes, Thomas Bowers, Arlen Langvardt
Posted Date:
Students also viewed these accounting questions
-
You decide to purchase a building for $30,000 by paying $5,000 down and assuming a mortgage of $25,000. The bank offers you a 15-year mortgage requiring annual end-of- year payments of $3,188 each....
-
If you decide to purchase the new machine the old machine could be sold today for 40000 The company has a 6 cost of capital and is in the 40 tax bracket
-
Part 1. Use the provided Excel spreadsheet for the Critical Thinking assignment for this week. On Worksheet 1, Assume the there are no capital loss carryforwards in each of the independent situations...
-
By applying modern technology to agriculture, the United States has become the most productive food-producing nation in the world. The secret to solving the world food security problem lies in...
-
Define and explain the theory of comparative advantage.
-
Consider the two-element dipole array of Fig. 9.29(a). If the two dipoles are excited with identical feeding coefficients (a0 = a1 = 1 and 0 = 1 = 0), choose...
-
A suitcase being loaded into an airplane moves at constant velocity on an inclined conveyor belt. Draw a free-body diagram for the suitcase as it moves up along with the belt. Show the normal and...
-
Rick has a $50,000 basis in the RKS General Partnership on January 1 of the current year, and he owns no other investments. He has a 20% capital interest, a 30% profits interest, and a 40% loss...
-
The price of a car you want is $39,000 today. Its price is expected to increase by $1000 each year. You now have $23,500 in an investment account, which is earning 11% per year. How many years will...
-
1. If Bozena participates and the 401(k) earns 10 percent annually, how much will she have accumulated in 45 years (to age 67) even if her salary does not change? 2. If she does not participate and...
-
(a) Consider an audio signal comprised of the sinusoidal term s(t) = 3 cos 500nt (i) Find the signal to quantization noise ratio when this is quantized using 10-bit PCM (4 marks) (ii) How many bits...
-
Consider the inverse demand function below for a market with 2 dominant firms: P=600-3(Q 1 +Q 2 ) Assume that both firms have identical marginal costs: $300, yet one of them, Firm 1, is the leader...
-
1. there are two different schools of thought on how to lower gasoline prices and reduce U.S. dependence on foreign oil. One is to increase supply of oil (drilling offshore), and the other is to...
-
The current in the 1 3 . 8 2 resistor is / 3 = 0 . 9 A . 1 . Find the current in the other resistors in thecircuit? 2 . What is the total energy dissipated in resistor 4 1 7 . 2 0 if the power supply...
-
A jewelry shop specializes in creating gold and silver charms. The shop has five metalsmiths who work on the charms. One week, the shop's production possibilities curve shifts inward. What could...
-
Explain how the Pakistan crisis will affect the following companies: a) MEIR Commodities India Pvt. Ltd., an agri commodity trading house exporting sugar, molasses, organics, etc. b) Honda, Toyota,...
-
1.Positive analysis involves the formulation and testing of hypotheses. involves value judgments concerning the desirability of alternative outcomes. weighs the fairness of a policy. examines if the...
-
Suppose the concentration of glucose inside a cell is 0.1 mm and the cell is suspended in a glucose solution of 0.01 mm. a. What would be the free energy change involved in transporting 10-o mole of...
-
A federal grand jury was investigating "John Doe," president and sole shareholder of "XYZ" corporation, concerning possible violations of federal securities and money-laundering statutes. During the...
-
Charles Peterson, a farmer and rancher, was indebted to Crown Financial Corporation on a $4,450,000 promissory note that was due on December 29, 1992. Shortly before the note was due, Crown sent...
-
One wheel of a pre-1916 automobile manufactured by the Buick Motor Company was made of defective wood. Buick could have discovered the defect had it made a reasonable inspection after it purchased...
-
Economy Appliance Co. manufactures lowprice, no-frills appliances that are in great demand for rental units. Pricing and cost information on Economys main products are as shown on page 943. Customers...
-
Van Hatten Consolidated has three operating divisions: DeMent Publishing Division, Ankiel Securities Division, and Depp Advisory Division. Each division maintains its own accounting system. DeMent...
-
Hui Hardware takes pride as the shop around the corner that can compete with the big-box home improvement stores by providing good service from knowledgeable sales associates (many of whom are...
Study smarter with the SolutionInn App