Thank you for your help!!

Vildcat Investment Company, LLC decided to purchase the investment property at 2912 N. Main Street. You ave been asked to complete the following tasks to complete the purchase. On the Closing tab of the spreadsheet, complete the Buyer's and Sellers' closing statements based on the following data (see Exhibit 8-8 in the text for guidance): - On June 15, Wilbur and Wilma Wildcat ("Sellers") listed their Flagstaff rental property for $599,900 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. - Wildcat Investment Company ("Buyer") offered $525,000 for the property. Wilbur and Wilma countered the offer and the parties agreed on a sales price of $550,500. At that time, the Buyer put down $1,000 of earnest money. - The Buyer will put 20% down and finance the rest through Bear Down Bank. The sale will close on July 1st at which time Wildcat 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 are $1,900 and will be paid by the Buyer at year-end. - 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 $2,000. - 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. You need to make a recommendation to Dr. Eller about the type of financing to use for the purchase. Using the three Amortization tabs on the spreadsheet, calculate your down payment, your monthly payment and create a loan amortization table for the five years you will hold the investment property for each of the three scenarios. Be sure to note the total interest and principal paid at the bottom of each table. - Fully Amortizing: 15-year fixed rate mortgage at 5.25%. - Adjustable Rate: 3/1 ARM, 15-year maturity, 4% initial rate which you anticipate will move up to 6% for years 4 and 5. - Interest Only: 8.5% interest rate that will not change for the next five years. - For detailed help on Amortization Tables, view the Amortization Example Video located in the Table of Contents Leaming Modules Week 7 area of D2L. Write a one-page persuasive business memo to Dr. Eller in which you: - Recommend the type of financing Wildcat Investments should use in the purchase of the investment property; - Comment on the Buyer and Seller closing costs to complete the transaction; - Notify Dr. Eller of the appreciation percentage required on the investment to overcome the transaction costs associated with the purchase (and eventual sale). Focus solely on the Settlement Charges for this portion of the discussion. 1) Use the data provided in the case description to complete the Buyer's and Sellers' Closing Statements below: \begin{tabular}{|l|l|l|l|l|} \hline Closing & Fully Amortizing & ARM & Interest Only & + \\ \hline Ready & \end{tabular} Vildcat Investment Company, LLC decided to purchase the investment property at 2912 N. Main Street. You ave been asked to complete the following tasks to complete the purchase. On the Closing tab of the spreadsheet, complete the Buyer's and Sellers' closing statements based on the following data (see Exhibit 8-8 in the text for guidance): - On June 15, Wilbur and Wilma Wildcat ("Sellers") listed their Flagstaff rental property for $599,900 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. - Wildcat Investment Company ("Buyer") offered $525,000 for the property. Wilbur and Wilma countered the offer and the parties agreed on a sales price of $550,500. At that time, the Buyer put down $1,000 of earnest money. - The Buyer will put 20% down and finance the rest through Bear Down Bank. The sale will close on July 1st at which time Wildcat 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 are $1,900 and will be paid by the Buyer at year-end. - 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 $2,000. - 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. You need to make a recommendation to Dr. Eller about the type of financing to use for the purchase. Using the three Amortization tabs on the spreadsheet, calculate your down payment, your monthly payment and create a loan amortization table for the five years you will hold the investment property for each of the three scenarios. Be sure to note the total interest and principal paid at the bottom of each table. - Fully Amortizing: 15-year fixed rate mortgage at 5.25%. - Adjustable Rate: 3/1 ARM, 15-year maturity, 4% initial rate which you anticipate will move up to 6% for years 4 and 5. - Interest Only: 8.5% interest rate that will not change for the next five years. - For detailed help on Amortization Tables, view the Amortization Example Video located in the Table of Contents Leaming Modules Week 7 area of D2L. Write a one-page persuasive business memo to Dr. Eller in which you: - Recommend the type of financing Wildcat Investments should use in the purchase of the investment property; - Comment on the Buyer and Seller closing costs to complete the transaction; - Notify Dr. Eller of the appreciation percentage required on the investment to overcome the transaction costs associated with the purchase (and eventual sale). Focus solely on the Settlement Charges for this portion of the discussion. 1) Use the data provided in the case description to complete the Buyer's and Sellers' Closing Statements below: \begin{tabular}{|l|l|l|l|l|} \hline Closing & Fully Amortizing & ARM & Interest Only & + \\ \hline Ready & \end{tabular}