Reply to thread

Message: <blockquote data-quote="sniper_89" data-source="post: 21281558" data-attributes="member: 540453">Excel වැඩ්ඩො එන්නා... ලොකු උදවව්ක් ඕනාලොකු උදව්වක් ඕනා... මේ  ප්‍රශ්න ටිකට උත්තර දන්නා කෙනෙක් ඉන්ව නම් කියල දෙනවද ??? Write appropriate MS Excel Financial function for the question below1.    A person intend to deposit Rs 15,000 at beginning of each month for next five years in a bank account. The annual interest paid by the bank is 12%. Calculate the amount that he will have in his account at the end of five years. Assume that the interest is paid at the end of each month. 2.    A person gets Rs 50,000 annually for 5 years and he deposit that money in the bank at the beginning of each year at the interest rate of 10% compounded annually what is the present value of this investment?  Assume that the interest is paid at the end of each year.3.     A person has taken a lon of Rs. 300,000 from a bank at an annual interest rate of 14%. He expect to pay back the loan in equal monthly payment within 8 years. What would be the monthly payment?4.    Suppose you have Rs 5000 to invest for period of 2 years at an interest rate 7.5 % per year. If the payment are due at the end of each month what is the interest payment at 8th month?5.    You want to purchase a house that requires quarterly payment. You want to spend no more than Rs 5,000 per quarter. For 30 year loan annual interest rate is 7.5 %. What is the most expensive house you can afford ??</blockquote>

Verification: Dawasata paya keeyak thibeda?

Top Bottom