List of Variables Used in the Template Reports

In this section, we list the variables (without the preceding tilde ~). that you can use in each report to customize the contents of that report, along with the corresponding description of that variable. The sections are in alphabetical order by the report name used on the Program Files\MPWin\Report folder.

The text files that go to Word have an extension of rpw (for example Balance.rpw). The text files that go to MasterPlan's report writer have an extension of rep (for example Balance.rep).

To edit them, use a text editor such as WordPad.

BALANCE: Statement Of Financial Condition

To generate this report, click on Reports | Present Baseline Scenario | Balance Sheet |Text Analysis.

BACASH	Value of cash assets (checking, savings, and money market accounts)
BABUYS	This variable equals 1 if this is proposed balance sheet
BAESTATE	Value of personal residence
BAASSTOT	Total asset value
BAPCASH	Cash asset percent of total assets
BAPSB	Stocks and mutual funds percent of total assets
BAPESTATE	Personal residence percent of total assets
BAPART	Value of limited partnerships
BAPPART	Limited partnerships percent of total assets
BANOTE	Value of notes
BAPNOTE	Notes percent of total assets
BARETIRE	Value of retirement plans
BAPRETIRE	Retirement plan percent of total assets
BAVALBUS	Value of business
BAPBUSVAL	Business percent of total assets
BAOTHER	Value of other property
BALIABTOT	Total liabilities
BASB	Value of stocks and mutual funds
BAPOTHER	Other property percent of total assets
BAWORTH	Net worth
BALASS	Value of liquid assets
BAPLASS	Liquid assets percent of total assets
BAPINC	Liquid assets as percent of yearly income

CAPNEED: Capital Needs Analysis

To generate this report, click on Reports | Worksheets | Capital Needs | Text Report.

CNDIES	Name of person who dies
CNSURV	Name of survivor
CNCAVAIL	Available capital
CNFINEX	Final expenses
CNADMIN	Estate administration costs
CNETAX	Estate tax
CNEDCOST	Education costs
CNEMRES	Amount to be held in emergency reserve fund
CNOTHEX	Other expenses
CNREEX	Mortgage expenses
CNIMNEED	Total expenses
CNONGO	On-going need
CNTOTNEED	Immediate capital required plus on-going need
CNPAVAIL	Shortfall
CNCPI	Consumer price index

EDUCATE: Education Cost Analysis

To generate this report, click on Reports | Worksheets | Education Needs | Text Report.

EDNUMCHILD	Number of children to be educated
EDTOTCOST	Total education expense
EDSTARTYR	First year of education expenses
EDENDYR	Last year of education expenses
EDRETONE	First supposed investment return
EDLUMPONE	Lump sum investment under investment return # 1
EDYRLYONE	Equal annual contribution under investment return # 1
EDMONONE	Monthly contribution under investment return # 1
EDCONYRS	Number of years in which contributions need to be made
EDALTS	Number of investment return alternatives selected

ESTATE: Estate Planning

To generate this report, click on Reports | Worksheets | Estate Planning | Reports | Estate Plan Text Report.

EPCLIENT	Name of first to die
EPSPOUSE	Name of last to die
EPCGROSS	Gross estate of first to die
EPSGROSS	Gross estate of last to die
EPCILIFE	Life insurance of last to die
EPSILIFE	Life insurance of first to die
EPCXPENSE	Final expenses of first to die
EPSXPENSE	Final expenses of last to die
EPCDEBT	Debts of first to die
EPSDEBT	Debts of last to die
EPCADJGROSS	Adjusted gross estate of first to die
EPSADJGROSS	Adjusted gross estate of last to die
EPCMTRUST	Amount to trust of last to die
EPFROMCLIENT	Amount from first to die carried forward to last to die
EPCREQLIQ	Liquidity required of first to die
EPSREQLIQ	Liquidity required of last to die
EPCNEED	Shortfall of first to die
EPSNEED	Shortfall of last to die
EPCTAXEST	Taxable estate of first to die
EPSTAXEST	Taxable estate of last to die
EPCETAX	Estate tax of first to die
EPSETAX	Estate tax of last to die
EPYSEC	Assumed calendar year of second death
EPDYR	Assumed calendar year of first death

FDIC: FDIC Balance Sheet

To generate this report, click on Reports | Present Baseline Scenario | Balance Sheet | Financial Condition Statement.

BABDATE	The date you have chosen to run the balance sheet for
BACFNAME	Client's full name
BACSFNAME	Spouse's full name
BAAONE	Client's street address
BAATWO	Client's city, state and zip
BACNUM	Client's Social Security Number
BASNUM	Second Client's Social Security Number
BAPHONE	Client's home phone number
BAWPHONE	Client's work phone
BACASHX	Liquid assets
BASBXXX	Securities
BABONDX	Bonds
BANOTEX	Notes
BAVLIFE	Cash value of life insurance
BAESTAT	Real estate values
BAPARTX	Partnership values
BARETIR	Retirement plan values
BAVALBU	Business interests
BAOTHER	Other assets
BAASSTO	Total assets
BASUNSEC	Total short-term unsecured liabilities
BASSEC	Total short-term secured liabilities
BALUNSEC	Total long-term unsecured liabilities
BALSEC	Total long-term secured liabilities
BALIABTOT	Total liabilities
BAWORTH	Net Worth
BAASSTOT	Total liabilities and net worth
BANCLIENT	Client's first name
BANSPOUSE	Spouse's first name
BACWAGE	Client's wages
BASWAGE	Spouse's wages
BAINTDIV	Total annual dividends and interest
BAOINV	Total other investment income
BAOEARN	Total other earned income
BACL	Contingent liabilities, yes or no
BAALIMO	The amount of any alimony or child support
BAAPLEDGE	Any assets pledged, yes or no
BADEFEND	Defendent in any lawsuits, yes or no
BAEVERBANK	Any past bankruptcy, yes or no

FINPJECT: Financial Overview

MasterPlan prints this after the Present Financial Overview when the beginning year equals the current year. All dollar amounts are for the first year of the projection.

To generate this report, click on Reports | Present Baseline Scenario | Overview | Text Report.

FPCNAME	Client name
FPSNAME	Spouse name
FPCYR	Current calendar year
FPYRLIFE	Calendar year of assumed life expectancy
FPRETYR	Calendar year of client retirement
FPAGERET	Client age at retirement
FPGROSS	Gross income
FPCINC	Client income (salary and self-employment)
FPSINC	Spouse income (salary and self-employment)
FPADJUST	Adjustments to income
FPWRITE	Write-offs
FPTAXINC	Taxable income
FPTTAX	Federal and state tax
FPMETH	Tax method chosen
FPBRACK	Combined tax bracket
FPYTWO	Calendar year for the second year
FPFREECASH	Tax free cash flow
FPLIVEX	Living expenses
FPEXLIVEX	Extraordinary living expenses
FPSSWITH	Social security withholding
FPLPEX	Loan and other expenses
FPINVEST	Investment expenses
FPTOTCASH	Total cash flow
FPANNFREE	Annual free cash
FPMMRATE	Money market rate
FPCONRET1	Retirement contributions
FPVALRET1	Total retirement plan value
FPCPI	Consumer price index
FORDLOSS	Ordinary Loss
FPCAPLOSS	Capital Loss
FPPASSLOSS	Passive Loss

GLOBAL: The Projection Assumptions Report

To generate this report, click on Reports | Plan Introduction | Plan Assumptions.

GLMONTH	Projection month
GLYR	Projection year
GLCPI	Consumer price index i.e. the overall inflation rate
GLLIFEX	Life expectancy of the client
GLINDEX	If it equals 1, you have answered the Index Tax Rates question with a Y for yes; if it does not equal 1, you have answered the same question with N for not. If you index tax rates, then the standard deduction amounts, personal exemptions, and Social Security withholding are also indexed.
GLSTATE	Two letter abbreviation for the State Tax Table used for this client.
GLMMRATE	Money Market Rate. It if equals .01, then you checked the Zero Surplus Cash Box, MasterPlan creates the line for the projection reports that says, Untracked Living Expenses, and the reports do not show any surplus cash. If it equals any other value, then MasterPlan assumes that it is the interest rate earned on any surplus cash. The paragraph also includes GLMMRATE, so the client can see the rate you have used.
GLMTAX	Whether or not the money market rate is taxable. If this equals 1, the interest earned on this surplus cash is taxable; if it does not equal 1, the interest earned on this surplus cash is tax free.
GLSAFE	The Modified Internal Rate of Return used to illustrate the efficacy of your financial planning and investment recommendations. MasterPlan assumes in some reports that any income tax savings and investment cash flows which come from proposed investments are reinvested at ~GLSAFE%.

INTRO and INTRO2: Letter and Disclaimer

There are no variables used in these reports.

To generate the client letter (Intro), click on Reports | Plan Introduction | Client Letter.

To generate the disclaimer (Intro2), click on Reports | Plan Introduction | Disclaimer.

REFI: Refinance Analysis

To generate this report, click on Reports | Real Estate Analysis. Select the Refinance button, and click on Text Report.

RFPNAME	Securing asset name (property name)
RFNEWAMT	New loan amount
RFLEXIST	Old loan current balance
RFLPERC	New loan rate
RFCASHREL	New released equity
RFYR2	Year 2 calendar year
RFAFTRET	Net cost of released equity (%)

RENT: Rental Property Analysis

To generate this report, click on Reports | Real Estate Analysis. Select the Rental button, and click on Text Report.

RECURRMV	Current market value
READDRESS	Address of property
RERENTINC	Monthly rental income
REMARGE	Year 1 marginal tax rate
REYPAY	Year 2 mortgage payments
REVALINC	Property rate of appreciation
REPNAME	Property name
REYR2	Year 2 calendar year
REEQUITY2	Year 2 equity
REEINC	Year 2 to year 3 increase in equity
RETAXINC2	Year 2 taxable income
REGROSS2	Year 2 pre-tax net cash flow
RETSAVE2	Year 2 tax savings
REWRITE2	Year 2 write-off
RETOTRET2	Year 2 percent return on equity
REVALINC%	Annual assumed increase in property value
REPTAXESC%	Annual assumed increase in property taxes
RERINCESC%	Annual assumed increase in rental income
REOPERESC%	Annual assumed increase in operating expenses

RESOWN: Residential Property Analysis

To generate this report, click on Reports | Real Estate Analysis. Select the Residential button, and click on Text Report.

RECURRMV	Current market value
READDRESS	Address of property
RERENTINC	Gross rental income
REMARGE	Marginal tax rate
REYPAY	Yearly mortgage payments
REVALINC	Rate of appreciation
REPNAME	Property name
REYR2	Year 2 calendar year
REEQUITY2	Equity in year 2
REEINC	Increase in equity, year 2 to year 3
RETAXINC2	Year 2 taxable income
REGROSS2	Year 2 pre-tax net cash flow
RETSAVE2	Year 2 tax savings
REWRITE2	Year 2 write-off
RETOTRET2	Percent return on equity

RETAN: Retirement Needs Analysis

To generate this report, click on Reports | Worksheets | Retirement Needs Analysis | Text Report.

RAADD	Additional monthly investments made toward retirement
RAAGE	Client's age at retirement
RACINV	First year monthly investment required if client continues to invest at their current after-tax rate
RACLIENT	Client's first name
RACURR	Current rate of return on working capital
RAEDUC	Year in which educational expenses start
RAESC	Retirement need, escalated to future value for first month of retirement
RAHINV	First year monthly investment required if client invests at your selected, assumed after-tax rate
RAHYPO	Selected, hypothetical after-tax rate of return on working capital
RAINF	Annual inflation rate on retirement needs
RALIFE	Age of client at life expectancy
RAMONT	Annual rate of increase in additional monthly investments toward retirement
RANEED	Calculated rate of return on capital needed to fund retirement through life expectancy
RARATIO	MasterPlan sets it to 1 if the client has enough money to last until retirement; to 0 if the resources are inadequate.
RAPUR	Monthly purchasing power desired at retirement
RASPOUSE	Spouse's first name
RASSB	Annual rate of increase in social security benefits
RATAX	Income tax rate at retirement (flat rate, not bracket)
RAWORK	Present working capital