False6Double-Declining DepreciationFalsedialogTrueFalseverticalTrueFalseend_CancelTrueTrueTrueFalseTrueFalseFalse0C_alculateTrueTrueTrueFalseTrueFalseFalse1FalseTrueend0TrueFalse666TrueFalse3535Calculates the depreciation allowance on an asset for a specified period of time, using the double-declining balance method.True40002TrueTrue●0FalseFalse12TrueTrue●0FalseFalse11TrueTrue●0FalseFalse13TrueFalse_Life:Trueddb_life002TrueFalse_Period:Trueddb_period003TrueFalseC_ost:Trueddb_cost001TrueTrue1button3button4False6Future ValueFalsedialogTrueFalseverticalTrueFalseend_CancelTrueTrueTrueFalseTrueFalseFalse0C_alculateTrueTrueTrueFalseTrueFalseFalse1FalseTrueend0TrueFalse666TrueTrue●0FalseFalse13TrueTrue●0FalseFalse12TrueTrue●0FalseFalse11TrueFalsePeriodic Interest _Rate:Truefv_pint002TrueFalse_Number of Periods:Truefv_n003TrueFalse3535Calculates the future value of an investment based on a series of equal payments at a periodic interest rate over the number of payment periods in the term.True40002TrueFalse_Periodic Payment:Truefv_pmt001TrueTrue1button5button6False6Gross Profit MarginFalsedialogTrueFalseverticalTrueFalseend_CancelTrueTrueTrueFalseTrueFalseFalse0C_alculateTrueTrueTrueFalseTrueFalseFalse1FalseTrueend0TrueFalse666TrueFalse3535Calculates the resale price of a product, based on the product cost and the wanted gross profit margin.True40002TrueTrue●0FalseFalse11TrueTrue●0FalseFalse12TrueFalseC_ost:Truegpm_cost001TrueFalse_Margin:True002TrueTrue1button19button20False6Periodic PaymentFalsedialogTrueFalseverticalTrueFalseend_CancelTrueTrueTrueFalseTrueFalseFalse0C_alculateTrueTrueTrueFalseTrueFalseFalse1FalseTrueend0TrueFalse666TrueFalse3535Calculates the amount of the periodic payment of a loan, where payments are made at the end of each payment period. True400002TrueTrue●0FalseFalse11TrueTrue●0FalseFalse12TrueTrue●0FalseFalse13TrueFalse_Term:Truepmt_n003TrueFalsePeriodic Interest _Rate:Truepmt_pint002TrueFalse_Principal:Truepmt_prin001TrueTrue1button7button8False6Present ValueFalsedialogTrueFalseverticalTrueFalseend_CancelTrueTrueTrueFalseTrueFalseFalse0C_alculateTrueTrueTrueFalseTrueFalseFalse1FalseTrueend0TrueFalse666TrueFalse3535Calculates the present value of an investment based on a series of equal payments discounted at a periodic interest rate over the number of payment periods in the term. True400002TrueTrue●0FalseFalse11TrueTrue●0FalseFalse12TrueTrue●0FalseFalse13TrueFalse_Number of Periods:Truepv_n003TrueFalsePeriodic Interest _Rate:Truepv_pint002TrueFalse_Periodic Payment:Truepv_pmt001TrueTrue1button9button10False6Periodic Interest RateFalsedialogTrueFalseverticalTrueFalseend_CancelTrueTrueTrueFalseTrueFalseFalse0C_alculateTrueTrueTrueFalseTrueFalseFalse1FalseTrueend0TrueFalse666TrueFalse3535Calculates the periodic interest necessary to increase an investment to a future value, over the number of compounding periods. True400002TrueTrue●0FalseFalse11TrueTrue●0FalseFalse12TrueTrue●0FalseFalse13TrueFalsePresent _Value:Truerate_pv002TrueFalse_Term:Truerate_n003TrueFalse_Future Value:Truerate_fv001TrueTrue1button11button12False6Straight-Line DepreciationFalsedialogTrueFalseverticalTrueFalseend_CancelTrueTrueTrueFalseTrueFalseFalse0C_alculateTrueTrueTrueFalseTrueFalseFalse1FalseTrueend0TrueFalse666TrueFalse_Cost:Truesln_cost001TrueTrue●0FalseFalse12TrueTrue●0FalseFalse11TrueTrue●0FalseFalse13TrueFalse_Life:Truesln_life003TrueFalse_Salvage:Truesln_salvage002TrueFalse3535Calculates the straight-line depreciation of an asset for one period. The straight-line method of depreciation divides the depreciable cost evenly over the useful life of an asset. The useful life is the number of periods, typically years, over which an asset is depreciated. True400002TrueTrue1button13button14False6Sum-of-the-Years'-Digits DepreciationFalsedialogTrueFalseverticalTrueFalseend_CancelTrueTrueTrueFalseTrueFalseFalse0C_alculateTrueTrueTrueFalseTrueFalseFalse1FalseTrueend0TrueFalse666TrueFalse_Period:Truesyd_period004TrueFalse_Life:Truesyd_life003TrueFalse_Salvage:Truesyd_salvage002TrueFalse_Cost:Truesyd_cost001TrueTrue●0FalseFalse11TrueTrue●0FalseFalse12TrueTrue●0FalseFalse13TrueTrue●0FalseFalse14TrueFalse3535Calculates the depreciation allowance on an asset for a specified period of time, using the Sum-of-the-Years'-Digits method. This method of depreciation accelerates the rate of depreciation, so that more depreciation expense occurs in earlier periods than in later ones. The useful life is the number of periods, typically years, over which an asset is depreciated. True400002TrueTrue1button15button16False6Payment PeriodFalsedialogTrueFalseverticalTrueFalseend_CancelTrueTrueTrueFalseTrueFalseFalse0C_alculateTrueTrueTrueFalseTrueFalseFalse1FalseTrueend0TrueFalse666TrueTrue●0FalseFalse13TrueTrue●0FalseFalse12TrueTrue●0FalseFalse11TrueFalse_Periodic Payment:Trueterm_pmt001TrueFalseFuture _Value:Trueterm_fv002TrueFalsePeriodic Interest _Rate:Trueterm_pint003TrueFalse3535Calculates the number of payment periods that are necessary during the term of an ordinary annuity, to accumulate a future value, at a periodic interest rate.True400002TrueTrue1button17button18FalseTrueFalseTrueTrueTrueTrueFalseTrueTrueFalse3TrueFalsexTrueTrue0TrueFalsedownFalseTrue1Memory422logTrueTrueFalseTrue628TrueTrueFalseTrueTrue109TrueTrueFalseTrueTrue205TrueTrueFalseTrueTrue116TrueTrueFalseTrueTrue21÷TrueTrueFalseTrueTrue302TrueTrueFalseTrueTrue12.TrueTrueFalseTrueTrue13%TrueTrueFalseTrueTrue233TrueTrueFalseTrueTrue22×TrueTrueFalseTrueTrue31−TrueTrueFalseTrueTrue32+TrueTrueFalseTrueTrue33=TrueTrueFalseTrueTrue432(TrueTrueFalseTrueTrue41)TrueTrueFalseTrueTrue51ClearTrueTrueFalseTrue50CtrmTrueTrueFalseTrueTrue70DdbTrueTrueFalseTrueTrue80FvTrueTrueFalseTrueTrue90TermTrueTrueFalseTrueTrue83SydTrueTrueFalseTrueTrue92SlnTrueTrueFalseTrueTrue82RateTrueTrueFalseTrueTrue72PvTrueTrueFalseTrueTrue91PmtTrueTrueFalseTrueTrue81GpmTrueTrueFalseTrueTrue71TrueTrueFalseTrueTrueFalse<i>x</i><sup><i>y</i></sup>TrueExponent60√TrueTrueFalseTrueTrue61UndoTrueTrueFalseTrue407TrueTrueFalseTrueTrue004TrueTrueFalseTrueTrue011TrueTrueFalseTrueTrue02050TrueTrueFalseTrueTrue03