FINANCIAL PROJECTION NUMBERS GENERATOR Input Monthly Rent 500 Input Monthly Mortgage Cost 250 Input Mortgage Amount borrowed

Document Sample
FINANCIAL PROJECTION NUMBERS GENERATOR Input Monthly Rent 500 Input Monthly Mortgage Cost 250 Input Mortgage Amount borrowed Powered By Docstoc
					FINANCIAL PROJECTION NUMBERS GENERATOR
Input Monthly Rent                                       500
Input Monthly Mortgage Cost                              250
Input Mortgage Amount borrowed                         50000
Input Value of Property                                75000

LONG TERM OPPORTUNITY FINANCIAL PROJECTION

                              Year 1       Year 2     Year 3     Year 4        Year 5      Year 6     Year 7
Annual Rent                   £6,000       £6,180     £6,365     £6,556        £6,753      £6,956     £7,164
Annual Mortgage Cost          £3,000       £3,000     £3,000     £3,000        £3,000      £3,000     £3,000
Annual Profit                 £3,000       £3,180     £3,365     £3,556        £3,753      £3,956     £4,164

Value Of Property            £75,000      £77,250    £79,568    £81,955       £84,413     £86,946    £89,554
Mortgage Balance             £50,000      £50,000    £50,000    £50,000       £50,000     £50,000    £50,000
Equity                       £25,000      £27,250    £29,568    £31,955       £34,413     £36,946    £39,554

Assumes a 3% annual growth rate of rental income and property value.                    Total Profit From 10 Years Ownership


MEDIUM TERM OPPORTUNITY FINANCIAL PROJECTION

                              Year 1       Year 2     Year 3     Year 4        Year 5
Annual Rent                   £6,000       £6,180     £6,365     £6,556        £6,753
Annual Mortgage Cost          £3,000       £3,000     £3,000     £3,000        £3,000
Annual Profit                 £3,000       £3,180     £3,365     £3,556        £3,753     £16,855

Value Of Property            £75,000      £77,250    £79,568    £81,955       £84,413
Mortgage Balance             £50,000      £50,000    £50,000    £50,000       £50,000
Equity                       £25,000      £27,250    £29,568    £31,955       £34,413     £34,413

Assumes a 3% annual growth rate of rental income and property value.

                                        Total Profit From 5 years ownership               £51,268


SHORT TERM OPPORTUNITY FINANCIAL PROJECTION

Monthly Rent                                 500
Monthly Mortgage Costs                       250
Money in to buy                             6000
Net Proceeds                              100000
Mortgage Balance                           60000




                             Month 1     Month 2     Month 3    Month 4       Month 5    Month 6    Month 7
Cash Inflow
Rent Received                    £500        £500       £500       £500         £500         £500
Net Proceeds from Sale
Total Inflow                     £500        £500       £500       £500         £500         £500         £0
Cash Outflow
Purchasing Costs              -£6,000
Mortgage Costs                  -£250      -£250      -£250      -£250     -£250     -£250
Redeem Mortgage
Total Outflow                 -£6,250      -£250      -£250      -£250     -£250     -£250        £0

Opening cash balance               £0    -£5,750    -£5,500     -£5,250   -£5,000   -£4,750   -£4,500
Movement                      -£5,750      £250       £250        £250      £250      £250         £0
Closing cash balance          -£5,750    -£5,500    -£5,250     -£5,000   -£4,750   -£4,500   -£4,500

Assumes you let the property for 6 months and then sell on month 12.
ENERATOR




                         Year 8        Year 9   Year 10     Total
                         £7,379        £7,601    £7,829
                         £3,000        £3,000    £3,000
                         £4,379        £4,601    £4,829   £38,783

                        £92,241   £95,008       £97,858
                        £50,000   £50,000       £50,000
                        £42,241   £45,008       £47,858   £47,858

Total Profit From 10 Years Ownership                      £86,641




                       Month 8    Month 9 Month 10 Month 11 Month 12


                                                                 £100,000
                             £0           £0        £0        £0 £100,000
                                        -£60,000
    £0        £0        £0        £0    -£60,000

-£4,500   -£4,500   -£4,500   -£4,500   -£4,500
     £0        £0        £0        £0   £40,000
-£4,500   -£4,500   -£4,500   -£4,500   £35,500

				
DOCUMENT INFO
Description: 10 Year Financial Projection document sample