Need Correct answer please

A DX AutoSum Fill - 2 Clear - Sort & Find & Filter Select Editing T U V w x X -- = Real Estate Final Fall 2021 2) - Microsoft Excel Product Activation Failed File Home Insert Page Layout Formulas Data Review View * Cut Calibri 11 AA Wrap Text General Copy Paste BIU Format Painter A F Merge & Center $ $ %, $ .00.0 09 Conditional Format Cell Insert Delete Format Formatting as Table Styles Clipboard Font Alignment Number Styles Cells E26 . fox A B D E F F G H H 1 j K L M N N o P R S s 1 Potential Rent 2 3 6 San Pablo Avenue, San Francisco CA has 5 Bedrooms and 6 Bathrooms on 4,000 square feet of living space. 4 You want to use most of the upstairs area as living area for your family 6 7 8 9 10 Each bedroom is 15 by 20 feet (300 square feet). 11 Average rental by square feet is $ 6 per square feet per month 12 13 In addition to the bottom living area, you believe that you can 14 rent one of your top living area bedrooms for a net of $100 per night for roughly 15 twenty nights in a thirty-day month. 16 17 18 What would be your estimated rental income from your house? 19 20 21 What is the difference between your rental income and the total cash flow as calculated in the Total Cost of Ownership tab? 22 23 24 25 26 27 28 29 30 Price Estimation & Downpayment Mortgage Calculation Total Cost of Ownership Income Required Potential Rents Investment Assessment REIT Ready HI 0 + B 87% e SD X 1:41 AM 12/3/2021 Filc A DTX AutoSum Fill - Insert Delete Format 2 Clear - Sort & Find & Filter Select Editing Cells x = Real Estate Final Fall 2021 2) - Microsoft Excel Product Activation Failed Home Insert Page Layout Formulas Data Review View * Cut Calibri 11 AA Wrap Text General a Copy Paste BIU FF Merge & Center $ %, % .:09 Conditional Format Cell .00.0 Format Painter Formatting as Table Styles Clipboard Font Alignment Number Styles T24 . fx A A B B D E F G H H 1 J K M N N 2 3 As you have completed your quantitative analysis for 6 San Pablo Avenue, 4 please write one to three paragraphs in the text box below detailing why you WOULD or why you WOULD NOT 5 seek to buy 6 San Pablo Avenue. There are no right or wrong answers, but you should reference 6 the quantitative work you did before. 7 8 9 Written Response: 9 0 R s US 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Price Estimation & Downpayment Mortgage Calculation Total Cost of Ownership Income Required Potential Rents NH Ready Investment Assessment REIT 0 BO 100% % + e 9 X 23 1:45 AM 12/3/2021 > of What would be wie esamateur own payment Use your estimated actual selling price Mortgage Calculation Subtracting the downpayment from your estimated sales price for 4101 Moraga Street, San Francisco CA will give you the overall mortgage amount What is the overall mortgage loan amount? (PV) Assume the following Annual Interest Rate (fixed) 4% Monthly Payments # of years 30 FV (paying off the mortgage) 0 What is your monthly mortgage payment? Use the PMT function (remember to convert the annual interest rate to monthly and to find the # of months to get the NPER) Please write the 30-year (360 month) mortgage amortization schedule below. At a minimum show the principal remaining, interest expense, cash payment and principal reduction every month. Total Cost of Ownership Page Name: Investments: Real Estate Final Assessment Price Estimation and Downpayment Mortgage Calculation Total Cost of Ownership Income Required Potential Rent Investment Assessment REIT Research Total 10% 30% 20% 10% 10% 10% 10% 100% A DX AutoSum Fill - 2 Clear - Sort & Find & Filter Select Editing T U V w x X -- = Real Estate Final Fall 2021 2) - Microsoft Excel Product Activation Failed File Home Insert Page Layout Formulas Data Review View * Cut Calibri 11 AA Wrap Text General Copy Paste BIU Format Painter A F Merge & Center $ $ %, $ .00.0 09 Conditional Format Cell Insert Delete Format Formatting as Table Styles Clipboard Font Alignment Number Styles Cells E26 . fox A B D E F F G H H 1 j K L M N N o P R S s 1 Potential Rent 2 3 6 San Pablo Avenue, San Francisco CA has 5 Bedrooms and 6 Bathrooms on 4,000 square feet of living space. 4 You want to use most of the upstairs area as living area for your family 6 7 8 9 10 Each bedroom is 15 by 20 feet (300 square feet). 11 Average rental by square feet is $ 6 per square feet per month 12 13 In addition to the bottom living area, you believe that you can 14 rent one of your top living area bedrooms for a net of $100 per night for roughly 15 twenty nights in a thirty-day month. 16 17 18 What would be your estimated rental income from your house? 19 20 21 What is the difference between your rental income and the total cash flow as calculated in the Total Cost of Ownership tab? 22 23 24 25 26 27 28 29 30 Price Estimation & Downpayment Mortgage Calculation Total Cost of Ownership Income Required Potential Rents Investment Assessment REIT Ready HI 0 + B 87% e SD X 1:41 AM 12/3/2021 Filc A DTX AutoSum Fill - Insert Delete Format 2 Clear - Sort & Find & Filter Select Editing Cells x = Real Estate Final Fall 2021 2) - Microsoft Excel Product Activation Failed Home Insert Page Layout Formulas Data Review View * Cut Calibri 11 AA Wrap Text General a Copy Paste BIU FF Merge & Center $ %, % .:09 Conditional Format Cell .00.0 Format Painter Formatting as Table Styles Clipboard Font Alignment Number Styles T24 . fx A A B B D E F G H H 1 J K M N N 2 3 As you have completed your quantitative analysis for 6 San Pablo Avenue, 4 please write one to three paragraphs in the text box below detailing why you WOULD or why you WOULD NOT 5 seek to buy 6 San Pablo Avenue. There are no right or wrong answers, but you should reference 6 the quantitative work you did before. 7 8 9 Written Response: 9 0 R s US 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Price Estimation & Downpayment Mortgage Calculation Total Cost of Ownership Income Required Potential Rents NH Ready Investment Assessment REIT 0 BO 100% % + e 9 X 23 1:45 AM 12/3/2021 > of What would be wie esamateur own payment Use your estimated actual selling price Mortgage Calculation Subtracting the downpayment from your estimated sales price for 4101 Moraga Street, San Francisco CA will give you the overall mortgage amount What is the overall mortgage loan amount? (PV) Assume the following Annual Interest Rate (fixed) 4% Monthly Payments # of years 30 FV (paying off the mortgage) 0 What is your monthly mortgage payment? Use the PMT function (remember to convert the annual interest rate to monthly and to find the # of months to get the NPER) Please write the 30-year (360 month) mortgage amortization schedule below. At a minimum show the principal remaining, interest expense, cash payment and principal reduction every month. Total Cost of Ownership Page Name: Investments: Real Estate Final Assessment Price Estimation and Downpayment Mortgage Calculation Total Cost of Ownership Income Required Potential Rent Investment Assessment REIT Research Total 10% 30% 20% 10% 10% 10% 10% 100%