An investor wishes to accumulate 200 PLN. How many months must the investor pay 40 PLN at the beginning of each month if the interest rate is 12% per annum, compounding annually. Solve the problem of non-integer value of the term of annuities. Rework example with deposits at the end of each month. Please solve in details.
Target Accumulation = 200 PLN, Monthly Payments = 40 PLN, Interest Rate = 12 % per annum or 1 % per month
Let the number of months be N for beginning of month deposits.
As per the laws of time value of money:
200 = 40 x (1.01)^(N) + 40 x (1.01)^(N-1) + .................+ 40 x (1.01)
200 = { [(1.01)^(N) - 1] / [0.01] } x 40 x (1.01)
[(1.01)^(N) - 1] = [200/40] x [1/(1.01)] x [0.01]
(1.01)^(N) = 1+ 0.049505
N =
= 4.856 month ~ 5 months
If deposits are made at the end of the month, then the equation would loook like as shown below:
200 = 40 x (1.01)^(N-1) + 40 x (1.01)^(N-2) + .................+ 40 x (1.01) + 40
200 = { [(1.01)^(N) - 1] / [0.01] } x 40
[(1.01)^(N) - 1] = [200/40] x [0.01]
(1.01)^(N) = 1.05
N =
= 4,90 months ~ 5 months
An investor wishes to accumulate 200 PLN. How many months must the investor pay 40 PLN...
An investor wishes to accumulate 200 PLN. How many months must the investor pay 40 PLN at the beginning of each month if the interest rate is 12% per annum, compounding annually. Solve the problem of non-integer value of the term of annuities. Rework example with deposits at the end of each month.
1. You won $100 000 in a lottery and you want to set some of that sum aside for 10 years. After 10 years, you would like to receive $2400 at the end of every 3 months for 8 years. How much of your winnings must you set aside if interest is 5.5% compounded quarterly? 2. A sum of money is deposited at the end of every month for 10 years at 7.5% compounded monthly. After the last deposit, interest...
5. This question consists of three parts. When performing the calculations, keep as many decimal places as you can for intermediate answers, but round your final answers to two decimal places. (7 marks total) You have taken out a loan that requires you to repay $200 per month for 10 years at 12% annual percentage rate with monthly compounding. The first payment occurs today. What is the current value of this loan? (2 marks) You have purchased a three-year...
1. Suppose you accumulated $500,000, perhaps from many years of saving. You put the money in a savings plan earning 6% compounded monthly. If you want to withdraw $4,000 at the beginning of each month, how long before the savings plan is exhausted? 2. Suppose you accumulated $500,000, perhaps from many years of saving. You put the money in a savings plan earning 6% compounded monthly. If you want the plan to last 40 years, how much can you withdraw...
AA 40. Each year, a shoe manufacturing company faces demands (which must be met on time) for pairs of shoes as shown in the file P03_40.xlsx. Employees work three consecutive quarters and then receive one quarter off. For example, a worker might work during quarters 3 and 4 of one year and quarter 1 of the next year. During a quarter in which an employee works, he or she can produce up to 600 pairs of shoes. Each worker is...
(Preparation of a cash budget) Lewis Printing has projected its sales for the first 8 months of 2016 as follows: January $140,000 April $300,000 July $200,000 February $100,000 May $255,000 August $200,000 March $170,000 June $180,000 Lewis collects 30 percent of its sales in the month of thesale, 40 percent in the month following the sale, and the remaining 30 percent 2 months following the sale. During November and December of 2015, Lewis's sales were...
10) An investment will pay you S120 in one year and $200 in two years. If the interest rate is 7%, what is the present value of these cash flows? A) S294.69 B) $286.84 C) $299.07 D) $320.00 11. A bank is negotiating a loan. The loan can either be paid off as a lump sum of $120.000 at the end of five years, or as equal annual payments at the end of each of the next five years. If...
5. Find the two roots of each of the following functions (that is find the two X values that make Y = 0). This skill may be useful in assignment 11. EXAMPLE: Y = 3X2 -11X +6 is the product of (3X -2)(X -3). If you let Y = 3X-2 then X = 2/3 will make Y = 0. If you let Y = X-3 then X = 3 will make Y = 0. Thus both X = 2/3 and X = 3 are roots. Show the algebra...
10) An investment will pay you 51 20 in one year and $200 in two years. If the interest rate is 7%, what is the present value of these cash flows? A) $294.69 B) $286.84 C) $299.07 D) $320.00 10) 11). TU) A bank is negotiating a loan. The loan can either be paid off as a lump sum of $120,000 at the end of five years, or as equal annual payments at the end of each of the next...
Calculate all of the problems in the document below in an Excel spreadsheet or on a financial calculator. Please show your work in order to get credit. For each problem, state the inputs given, what you are being asked to find (the missing input), and then use the Finance function to get the correct answer (if using Excel). 1. If you wish to accumulate $100,000 in 5 years, how much must you deposit today in an account that pays an...