(Annual Percentage Rate / Pmts per Year)
Rate for PMT?
(# of Years * Pmts per Year
Nper for PMT?
In order to calculate the Future Value of a stream of monthly cash flows which start immediately, and also include an additional lump sum at the beginning of the transaction, the value in the PMT argument should equal the Lump Sum amount plus the monthly Payment amount.
The "values" argument in the formula =IRR(values,guess) is a list of positive and negative cash flows.
In financial functions, if the Type argument is left blank, the f unctionwill assume that payments will start at end of the first payment period.
annual percentage yield (APY)
The equivalent yearly simple interest rate that takes into account compounding is the _____.
Changing the value in the Nper argument in financial functions will also affect the interest compoundng frequency.
When making loan payments, a proportion of each payment goes to pay off the interest accrued each period, and a proportion of each payment goes to reduce the principal (amount owed on the loan).
Setting up a loan amortization table is a standard method of detailing the transactions of a loan.
Cash received is considered a _____ cash flow.
A deposit of $10,000 in a certificate of deposit that pays simple interest of 2% per year for a period of 4 years would be owed _____ interest at the end of the 4 years.
The _____ is the time it will take to earn sufficient profits so that the loan can be repaid.
When calculating taxes in the United States, a company can expense or subtract from income only the _____ portion of a loan payment.
When making loan payments, as the princip allowed on the loan is slowly lowered,a larger proportion of the payment amount goes to reducing the prinicipal owed.
When making loan payments, as the principal owed on the loan is slowly lowered, the proportion of the payment amount applied to interest increases.
Cash paid out in a transaction is considered a _____ cash flow.
_____ is the process by which a company spreads the expense of an asset over its useful life.
Beginning lump sums (or balances) do indeed go in the PV argument box...whenever there is a PV argument (like when using the FV and PMT functions). When using the PV function to calculate the Present Value, there is no PV argument...therefore in that case (and that case only), since there is no PV argument, the PV gets added to the end. </p> <p>The Present Value of a beginning lump sum is just that amount...no interest calculations need to be made with this value, therefore it can just be added to the result of the PV calculation being used to calculate Present Value.
When calculating a future value, enter beginning lump sum amounts and beginning balances in the PV argument box.
A _____ is additional money required from the borrower at the end of a loan.
If there is not a FV argument box (such as when you're calculating Future Value), add the Ending Lump Sum to the end of the formula (added outside of the FV function).
The lower the net present value (NPV), the more profitable the project.
Payments made at the beginning of each period are indicated by a Payment_type of _____.
The payment Type does not affect lump sum amounts...it only applies to periodic payments (located in the PMT box).
Adding interest earned each period to the principal and then computing interest for the next period is _____ interest.
You can define a range name for a value not listed in any worksheet.
The _____ argument of the PMT function refers to the value at the end of the transaction.
In financial functions, an argument Type of _____ indicates payments are made at the end of each period.
When using the PMT function, the argument which represents to total number of payment is _____.
The _____ argument of the PMT function refers to the original principal value at the beginning of the transaction.
Return on investment (ROI)
_____ is the sum of the cash flows, excluding the initial investment, divided by the investment value
"Compound interest" is when you add interest earned each period to the principal and then use that value to compute interest for the next period.
"Simple interest" is when you add interest earned each period to the principal and then use that value to compute interest for the next period.
Simple interest is equal to _____ multiplied by the interest rate per time period multiplied by the number of time periods.
In the Unites States, a company can deduct only the amount paid towards interest as an expense (which effectively reduces the amount of income taxed).
In the Unites States, a company can deduct amounts paid towards both the interest and the principal as expenses (which effectively reduces the amount of income taxed).
When calculating loan payments, to show a down payment toward the purchase of an asset, you must adjust the _____ argument of the financial function..