![]() ![]() The depreciation amount for the first year is 13,333.33 currency units. You want to calculate depreciation for the first year. The salvage value is to be 10,000 currency units. RECEIVEDĬalculates the amount received that is paid for a fixed-interest security at a given point in time.Ī video system initially costing 50,000 currency units is to be depreciated annually for the next 5 years. Examples of this type of application are found under the depreciation functions. Please note: references to constants must be defined as absolute references. If you enter references instead of these values into the formula, you can calculate any number of "If-then" scenarios. The difference between this amount and the 35,000 currency units deposited represents the interest paid. Cross-checking shows that 48 x 500 currency units + 20,000 currency units = 44,000 currency units. ![]() Under the named conditions, you must deposit 35,019.37 currency units today, if you want to receive 500 currency units per month for 48 months and have 20,000 currency units left over at the end. What is the present value of an investment, if 500 currency units are paid out monthly and the annual interest rate is 8%? The payment period is 48 months and 20,000 currency units are to remain at the end of the payment period. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |