Quick guide to financial formulas for 1-2-3 users
Dozens of real-world examples make this book meaningful for virtually every user of 1-2-3, from student to top financial manager. The book provides brief explanations of each formula, and includes simple spreadsheet models that break the foruula down into steps.
What people are saying - Write a review
We haven't found any reviews in the usual places.
Present Value of a Future
Analyzing Loans Leases and Savings
32 other sections not shown
amount Annual Interest APR annual percentage rate annuity due balloon loan balloon payment basic beginning balance Building a Model calculate the payments calculating payments calculating the future cash flows cell references Chapter column compound interest compounded monthly compounding period cost data table database deduction dividends division by zero dP dP effective annual rate entry Esmerelda example exemption format formula function future value investment lease lookup table Lotus lump sum MACRS midyear model for calculating month monthly payments mortgage Number of Payments number of periods ordinary annuity payment period Payments/Year periodic interest rate placed in service present value range name rate of return reach a goal regression regression analysis Release 2.0 residual value result return ERR messages salvage value schedule shown in Figure simply string tax calculation taxable income term tion Total Value of Payments variables worksheet