Find: 1. Value of property at 6% Cap Rate 2. Debt Service (P&I) assuming 80% LTV 30 year fixed at 5% 3. Cash on cash 4. Which Expenses may be missing? Account Name Operating Income & Expense % of Fiscal Year To Selected Period % of Selected Period Fiscal Year To Date Date Income Rent 196.694.95 98.94 196,694,95 98.94 Pet Rent 225.00 0.11 225.00 0.11 NSF Fees Collected 50.00 0.03 50.00 0.03 Application Fee Income 40.01 0.02 40.01 0.02 Laundry Income 816.02 0.41 816.02 041 Late Fee 442.50 0.22 442.50 022 Administrative Fee 602.22 0.30 602.22 0.30 Amenities -70.00 -0.04 70.00 0.04 Total Operating Income 198.800.70 100.00 198,800.70 100.00 Expense Inspection 1.050.00 0.53 1.050.00 0.53 Pest Control 297.00 0.15 297.00 0.15 HVAC (Heat. Ventilation, Air) 1,163.28 0.59 1.163.28 0.59 Janitorial Expense 1,080.00 0.54 1,080.00 054 Sprinklers 130 00 0.07 130.00 0.07 Management Feen 16760-81 742 14.760.81 742 tv A MacBook Air onatha/Downloads/HW%20Problem%20%231% 20 (2).pdf 1/1 Sprinklers Management Fees General Property Maintenance Expense Lock Replacement Maintenance expense General Repair-Projects Carpet Cleaning 141% + 150:00 0:07 10000 14,760.81 7.42 14,760.81 7.42 -50.00 -0.03 50.00 -0.03 6.136.93 3.09 6,136.93 3.09 1,978.27 1.00 1.978 27 1.00 120.00 0.06 120.00 0.06 Snow Removal 3,170.00 1.59 3.170.00 1.59 Lawn Mowing 1,170.00 0.59 1,170.00 0.59 Maintenance Expenses 8,832.22 444 8.832 22 4.44 Total General Property 21,357,42 10.74 21,357.42 10.74 Maintenance Expense Electricity 1,733.37 0.87 1,733.37 0.87 Gas 8.167.82 4.11 8.167.82 411 Water 7.957.84 4.00 7,957 841 4.00 Garbage and Recycling 3.561.66 1.79 3.561.96 1.79 Plumbing 3,462.67 1.74 3,462 67 1.74 Flooring 1.795.79 0.90 1.796.79 0.90 Equipment/Tools 15.00 0.01 15.00 0.01 Total Operating Expense 66.532.66 33.47 66,532.66 33.47 NOI-Net Operating Income 132.268.04 66,53 132,268.04 66.53 100.00 Total Income 198.800.70 100.00 198.800.70 tv A