Excel වැඩ්ඩො එන්නා... ලොකු උදවව්ක් ඕනා
ලොකු උදව්වක් ඕනා... මේ ප්රශ්න ටිකට උත්තර දන්නා කෙනෙක් ඉන්ව නම් කියල දෙනවද ???
Write appropriate MS Excel Financial function for the question below
1. 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 ??
ලොකු උදව්වක් ඕනා... මේ ප්රශ්න ටිකට උත්තර දන්නා කෙනෙක් ඉන්ව නම් කියල දෙනවද ???
Write appropriate MS Excel Financial function for the question below
1. 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 ??
Last edited:
