On October $1$ Computer Solutions purchased an office building for $$473,000,$ which included land, building, and office equipment. The purchase was financed with a $30$ year loan from the bank with an interest rate of $5\%($ordinary annuity$).$ The first payment is due November $1.$ Appraisal of the property came in at $$525,000$ with land appraised at $$200,000$; building, $$275,000,$ and office equipment, $$50,000.$ For this assignment you need to calculate the amount to be allocated to each fixed asset category $($round to nearest dollar$),$ plus you need to calculate the monthly loan payment. An Excel file needs to be created and saved $($your$\_$name QB Part $2)$ that includes a sheet for the amortization schedule and a sheet showing how you determined the allocation of the purchase price. The purchase allocation should be completed in Excel using a formula. This file will be submitted with Part $2$ reports.

Please show the amortization schedules in excel format