Can you please answer all parts to question 2!!!

Ann is looking to buy an office building in 2023. She plans to rent it out for 5 years (20242028) and sell it at the end of 2029. (1) Use the first sheet of the spreadsheet (titled "NOI") to compute the Net Operating Income (NOI) for this property for 2024. Fill in the missing information in the spreadsheet. This property has two types of operating income, rental income and parking. Rental Income in 2024= ( # square feet ) (Annual rent per square foot in 2024) Parking is a fixed dollar amount given Vacancy expenses in 2024=( Rental vacancy rate in 2024)* ( rental income in 2024) Collection losses in 2024= (collection loss rate in 2024)*(PGI in 2024) Operating Expenses in 2024= (Operating expense rate in 2024)* (EGI in 2024) (1.a) What is the NOI for 2024 ? (1.b) If this building is being sold in 2023 at an asking cap rate of 8.50%, what is the asking price? (2) Fill in the second sheet (titled "underwriting"). Where it says "Income Test", compute the biggest mortgage payment Ann can make given her NOI in 2024 computed above. Recall from slides 12:PMTNOI1.20, which implies the maximum PMT =1.20NOI. (2.a) What is the biggest mortgage payment the bank will allow Ann to make given her expected NOI in 2024? Using the maximum payment, compute the maximum loan Ann can get. Recall for an IO loan: PMT =( interest rate )( Loan Balance ) The interest rate is given in the spreadsheet (7.5\%). Use the PMT computed in (2.a) (2.b) What is the maximum loan amount corresponding to a DSCR of 1.2 ? (2.c) What is the biggest loan Ann can get with a $5,000,000 down payment and 85% maximum LTV? NOTE: you may use the formula Maximum Loan =((LTV)/(1LTV)) Down payment. (2.d) Assume for the rest of the question that Ann will make a $5,000,000 down payment. How much will Ann need to borrow? (2.e) What will Ann's annual debt service payment be? Inputs \begin{tabular}{|c|c|c|c|} \hline Annual Interest Rate & 7.50% & O loan, 5-year balloon & Income Test \\ \hline Minimum DSCR & 1.20 & & Maximum Annual Mortgage Payment \\ \hline Maximum LTV & 85% & & Maximum Loan Amount \\ \hline Downpayment & $5,000,000.00 & & \\ \hline Asking Price & $10,004,529.40 & & Collateral Test \\ \hline NOI 2024 & $850,385.00 & & Maximum Loan Amount w/ downpayment \\ \hline & = & & \\ \hline & & a & Both tests \\ \hline & +1 & & Maximum Loan Amount \\ \hline= & & = & Debt Service Payment \\ \hline & & & \\ \hline & & & Ann makes a $5,000,000 downpayment \\ \hline & & & Loan amount to buy the property \\ \hline & & & Debt Service Payment \\ \hline \end{tabular}