Mary Chong, capital expenditure manager for PDA Manufacturing, knows that her co
ID: 2652776 • Letter: M
Question
Mary Chong, capital expenditure manager for PDA Manufacturing, knows that her company is facing a series of monthly expenses associated with installation and calibration of new production equipment. The company has $1 million in a bank account right now that it can draw on to meet these expenses. Funds in this account earn 6% interest annually, with monthly compounding. Ms Chong is preparing a budget that will require the company to make equal monthly deposits into their bank account, starting next month, to ensure that they can pay the repair costs they anticipate over the next 24 months (shown as follows). How much should the monthly bank deposit be? Months Repair Costs per Month 1–4 $100,000 5–12 $200,000 13–24 $500,000.
Explanation / Answer
Present value $ 1,000,000.00 Rate 6%/12 0.500% Nper 24 Months Present Value of Future Liabilities = Present Value of Required Funding Annuity Present Value of Future Liabilities = Months Repair cost per months PV @ 0.500% Present Value 1 $100,000 0.995025 $99,502.49 2 $100,000 0.990075 $99,007.45 3 $100,000 0.985149 $98,514.88 4 $100,000 0.980248 $98,024.75 5 $200,000 0.975371 $195,074.13 6 $200,000 0.970518 $194,103.62 7 $200,000 0.96569 $193,137.93 8 $200,000 0.960885 $192,177.04 9 $200,000 0.956105 $191,220.94 10 $200,000 0.951348 $190,269.59 11 $200,000 0.946615 $189,322.97 12 $200,000 0.941905 $188,381.07 13 $500,000 0.937219 $468,609.62 14 $500,000 0.932556 $466,278.23 15 $500,000 0.927917 $463,958.44 16 $500,000 0.9233 $461,650.19 17 $500,000 0.918707 $459,353.42 18 $500,000 0.914136 $457,068.08 19 $500,000 0.909588 $454,794.11 20 $500,000 0.905063 $452,531.45 21 $500,000 0.90056 $450,280.05 22 $500,000 0.89608 $448,039.85 23 $500,000 0.891622 $445,810.80 24 $500,000 0.887186 $443,592.83 Total Present value of future Liabilities $7,400,703.92 Present Value of Required Funding Annuity = Annuity x 22.5629 + 1,000,000 Putting into the equation = Present Value of Future Liabilities = Present Value of Required Funding Annuity $7,400,703.92 = Annuity x 22.5629 + 1,000,000 Annuity $283,682.68 Annuity factor = (1-(1.005)/^-24)/.005 22.56286622