Fonda Money's Excel Financial Planning Guide
Edition: 1
Copyright: 2018
Pages: 36
Edition: 1
Copyright: 2018
Pages: 36
Choose Your Format
$38.59
Ebook
$26.46
Simply said, financial planning is an ongoing effort to avoid future financial distress. Key variables include present and future worth, rates of return, and time. Want to know how many months or what rate of return is required to reach a savings goal? What about today’s cost of future income? Or the risk and return from stocks? Fonda Money’s Excel Financial Planning seeks answers to 25 inevitable questions for successful financial planning.
Fonda Money’s Excel Financial Planning was originally created for college business students who needed to solve time-value-of-money problems using their computers. The spreadsheet approach supplants earlier methods tied to tables, equations, and calculators. The broader audience may be those students’ parents and grandparents who want to solve TVM problems for real. In either case, Fonda Money is here to make her users fond of their financial planning.
$
FUTURE WORTH of a
Single deposit compounded annually
Single deposit compounded non-annually
Series of year-ending deposits
Series of year-beginning deposits
Series of month-ending deposits
Series of month-beginning deposits
$
PRESENT WORTH of a
Single future payoff
Series of year-ending uniform future payoffs
Series of year-beginning uniform future payoffs
Series of delayed uniform future payoffs
Series of non-uniform future payoffs
%
RATE OF RETURN from a
Single future payoff
Series of uniform future deposits
Series of uniform future payments
Series of non-uniform future payoffs
$
PAYMENT of
Monthly sums to reach a savings goal
Monthly sums to repay a loan
NUMBER OF PERIODS to
Earn a single future payoff
Reach a savings goal with monthly deposits
Repay a loan with monthly payments
INVESTMENT ANALYSIS with
Historical average (or Arithmetic mean)
Compound rate of return (or Geometric mean)
Standard deviation
Correlation
Beta