Cash Flow Analysis Worksheet - - 2nd Mortgage 10 -...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Cash Flow Analysis Worksheet Property Name Prepared For Prepared By Date Prepared Purchase Price Plus Acquisition Costs Plus Loan Fees/Costs Less Mortgages Equals Initial Investment Mortqaqe Data Cost Recoverv Data 1st Mortqaqe 2nd Mortqaqe lmDrovements Personal Prooertv Amount lnterest Rate Amortization Period Loan Term Payments/Year Periodic Payment Annual Debt Service Loan Fees/Costs Value C. R. Method UsefulLife In Service Date Future Sale Date Recaoture lnvestment Tax Credit ($$ or %) Taxable Income 1 PotentialRentallncome 2 - 3 = Effective Rentallncome 4 + Other Income (Collectable) 5 = Gross Operating Income 6 - Operating Expenses 7 = NET OPEMTING INCOME B - Interest - 1st Mortgage 9 -
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: - 2nd Mortgage 10 - Participation Payments 11 - Cost Remvery - lmprovements 12 - Cost Recovery- Personal Property 13 - Amortization of Loan Fees/Costs 14 - Leasing Commissions 15 = Real Estate Taxable lncome 16 Tax Liability (Savings) al o/o 1 7 1 8 1 9 20 21 22 23 24 NET OPEMTING INCOME (Line 7)- A n n u a l D e b t S e r v i c e- Participation Payments- Leasing Commissions- Funded Reserves = CASH FLOW BEFORE TAXES- Tax Liability (Savings) (Line 16) = CASH FLOW AFTER TAXES Cash Flow Copyright @ 2008 by the CGIM Institute The statements and figures herein, while not guaranteed, are secured from sources we believe authoritative,...
View Full Document

This note was uploaded on 04/25/2010 for the course FIN 497 taught by Professor Clements during the Spring '10 term at University of Missouri-Kansas City .

Ask a homework question - tutors are online