Show how this function is used in excel spread sheet.
CS Professional · Valuations & Business Modelling · PYQS · June 2019
Show how this function is used in excel spread sheet.
Answer & Explanation:
Interest = FV SCHEDULE (100000,C4: C8) 8% 8% 6.50% 6% 6% It is to be noted that in place of C4:C8 students may assume other cells also.
Topics: Financial Functions
Related Questions in this Topic
- Which excel function is used for this calculation?
- Using Excel function, calculate the future value of an investment of ₹1,00,000/ over 5 years. The investment earns inter...
- A banker is reviewing your proposal for grant of long term loan and working capital facilities. What are the key ratios ...
- Explain the concepts of percentage of sales method and regression analysis method in estimating working capital with the...
- Prepare cash flow statement from the table and information given below: Liabilities 31st March, 2000 31st March, 2...