Purchase Price per $100 for a Bond on an Interest Date PRICE
The purchase price per $100 for a bond on an interest date can be calculated using Excel's PRICE function. See the table below for a detailed list of the exercises and problems in the text that
Periodic (Annuity) Payments PMT
The periodic payment or deposit for an annuity can be calculated using Excel's PMT function. See the table below for a detailed list of the exercises and problems in the text that can be solved using this function. Syntax -
Net Present Value NPV
The net present value of a series of cash flows can be calculated using Excel's NPV function. See the table below for a detailed list of the exercises and problems in the text that can be solved using this function. Syntax =NPV(rate,
Total Number of Compounding Periods NPER
The total number of compounding periods of an investment or an annuity can be calculated using Excel's NPER function. See the table below for a detailed list of the exercises and problems in the text that can be so
Least Common Multiple LCM
The least common multiple can be calculated using Excel's LCM function. See the table below for a detailed list of the exercises and problems in the text that can be solved using this function. This function is included in the An
Internal Rate of Return IRR
One way to determine the internal rate of return of a project is to use linear interpolation. The manual procedures for performing linear interpolation are explained and demonstrated in Chapter 16, on pages 719 to 720. Excel ha
Introduction to Excel Functions and Templates
In Excel, a function is a predefined or built-in formula for a commonly used calculation. Each function has a name and a Syntax. Syntax Syntax is the rule a function follows, using the following format: =FUNCT
Interest Rate INTRATE
The simple interest rate can be calculated using Excel's INTRATE function. See the table below for a detailed list of the exercises and problems in the text that can be solved using this function. This function is included in the Ana
Greatest Common Divisor GCD
The greatest common divisor can be calculated using Excel's GCD function. See the table below for a detailed list of the exercises and problems in the text that can be solved using this function. This function is included in th
Future Value FV
The future value of an investment or an annuity can be calculated using Excel's FV function. See the table below for a detailed list of the exercises and problems in the text that can be solved using this function. Syntax -FV(rate,number o
Effective Annual Interest Rate EFFECT
The effective annual interest rate can be calculated using Excel's EFFECT function. See the table below for a detailed list of the exercises and problems in the text that can be solved using this function. This functi
Depreciation using Fixed Declining Balance Method DB
The depreciation charge or expense of an asset for any one specific period of time using the complex-declining balance method can be calculated using Excel's DB function. See the table below for a detai
Amount of Principal Repaid CUMPRINC
The amount of principal repaid, in a single payment or consecutive payments, can be calculated using Excel's CUMPRINC function. See the table below for a detailed list of the exercises and problems in the text that can
Amount of Interest Paid CUMIPMT
The amount of interest paid, in a single payment or consecutive payments, can be calculated using Excel's CUMIPMT function. See the table below for a detailed list of the exercises and problems in the text that can be solve
Coupon Periods Remaining Between Settlement Date and Maturity Date COUPNUM
The number of coupon periods between the settlement date and the maturity date, rounded up to the next whole coupon period, can be calculated using Excel's COUPNUM function. See th
Number of Days from the Settlement Date to the Next Interest Date COUPDAYSNC
The number of days from the settlement date to the next interest date can be calculated using Excel's COUPDAYSNC function. See the table below for a detailed list of the exercise
Coupon Days Before Settlement COUPDAYBS
The number of days from the last interest date to the settlement date can be calculated using Excel's COUPDAYBS function. See the table below for a detailed list of the exercises and problems in the text that can be
Coupon Days in the Settlement Period COUPDAYS
The number of days in the compounding period that contains the settlement date can be calculated using Excel's COUPDAYS function. See the table below for a detailed list of the exercises and problems in the te
Simple Arithmetic Average AVERAGE
The simple arithmetic average can be calculated using Excel's AVERAGE function. See the table below for a detailed list of the exercises and problems in the text that can be solved using this function. Syntax =AVERAGE(num
Accrued Interest at Maturity ACCRINTM
The amount of accrued simple interest for an investment that has a one-time payment, at maturity, can be calculated using Excel's ACCRINTM function. See the table below for a detailed list of the exercises and problem
Accrued Simple Interest ACCRINT
The amount of accrued simple interest since the last interest date can be calculated using Excel's ACCRINT function. See the table below for a detailed list of the exercises and problems in the text that can be solved using
Annual Yield for a Discounted Security YIELDDISC
The annual yield for a discounted security can be calculated using Excel's YIELDDISC function. See the table below for a detailed list of the exercises and problems in the text that can be solved using this
Accumulation of Principal Year 1 2 3 4 5 6 Amount, beginning of year 0.00 0.00 0.00 0.00 0.00 Interest Amount, end of year 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0
Depreciation Schedule End of year 0 1 2 3 4 5 Total Annual depr. expense #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Accumulated depr. #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Book value #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Residual value n
Reduce to Lower Terms First Integer Second Integer Greatest Common Divisor 210 252 42 Final Result 5 6
Section Average Course Average 82 81 68 72.4 88 68.9 72 74.1 78 96 83 81
LCM Function Original Denominator First Integer Second Integer Third Integer Le
AVERAGE Function Mike Marks Math Accounting Psychology History Geography 77 84 69 92 71 78.6 Sue 85 72 74 n/a 80 77.75
Average
ACCPRINT Function Issue Date First Interest Date Settlement Date Interest Rate Value Frequency Basis Answer # # # 4% $1,255.41 1