In: Accounting
As the owner of a vinyl fencing company, you are making plans for two large purchases in the next 3 to 5 years to achieve your business goals. Purchase 1: You plan to expand your vinyl fence company in the future, and must purchase a new warehouse facility to achieve this goal. Your insurance company is offering you two very attractive investment options, an ordinary annuity and an annuity due, both compounding quarterly and paying 8% annual interest over a 5-year period. Your 5-year budget includes saving $2,500.00 each quarter. To evaluate which option will benefit the business most, you must evaluate both annuity options by calculating the future value of each option and explain how the investment will help you to carry out your goals. Purchase 2: After careful review of your maintenance log, you also realized that you will need to replace a fence post molding machine that sells for $45,000.00. You estimate that you will need to purchase a new machine in 3 years’ time as this machine reaches the end of its useful life. You plan to save for this purchase using a sinking fund that compounds semi-annually, and earns a 12% annual rate.
Your essay should in include the following information
1. Calculate the future value of both the ordinary annuity and the annuity due options being offered by your insurance company. Explain the differences between these two investment options. Select the best annuity option for your business and explain why that option is preferable.
2. Calculate the sinking fund payment required for the fence post molding machine.
3. Compare and contrast the shorter timeframe and higher interest rate of the sinking fund with the longer term warehouse annuity option you chose. Be sure to calculate and report how much interest you will earn from the annuity chosen for the warehouse and the amount of the sinking fund investment.
4. Develop a plan to prioritize these two purchases, and discuss the potential impact that these will have on the future of your business. For example, is expanding your business more important than saving for and paying cash for a fence post molding machine? Remember, you could borrow money to finance the fence post molding machine when it eventually breaks, but financing will cost the business in finance charges.
...any citations would help for clarity, thanks
Answer:
Purchase-1
Option- Ordinary Annuity
No. of Quarter= 20 (5 year)
Quarter |
Beg.bal. |
Interest |
Installment |
End. Bal. |
1 |
$0.00 |
$0.00 |
$2,500.00 |
$2,500.00 |
2 |
$2,500.00 |
$50.00 |
$2,500.00 |
$5,050.00 |
3 |
$5,050.00 |
$101.00 |
$2,500.00 |
$7,651.00 |
4 |
$7,651.00 |
$153.02 |
$2,500.00 |
$10,304.02 |
5 |
$10,304.02 |
$206.08 |
$2,500.00 |
$13,010.10 |
6 |
$13,010.10 |
$260.20 |
$2,500.00 |
$15,770.30 |
7 |
$15,770.30 |
$315.41 |
$2,500.00 |
$18,585.71 |
8 |
$18,585.71 |
$371.71 |
$2,500.00 |
$21,457.42 |
9 |
$21,457.42 |
$429.15 |
$2,500.00 |
$24,386.57 |
10 |
$24,386.57 |
$487.73 |
$2,500.00 |
$27,374.30 |
11 |
$27,374.30 |
$547.49 |
$2,500.00 |
$30,421.79 |
12 |
$30,421.79 |
$608.44 |
$2,500.00 |
$33,530.22 |
13 |
$33,530.22 |
$670.60 |
$2,500.00 |
$36,700.83 |
14 |
$36,700.83 |
$734.02 |
$2,500.00 |
$39,934.85 |
15 |
$39,934.85 |
$798.70 |
$2,500.00 |
$43,233.54 |
16 |
$43,233.54 |
$864.67 |
$2,500.00 |
$46,598.21 |
17 |
$46,598.21 |
$931.96 |
$2,500.00 |
$50,030.18 |
18 |
$50,030.18 |
$1,000.60 |
$2,500.00 |
$53,530.78 |
19 |
$53,530.78 |
$1,070.62 |
$2,500.00 |
$57,101.40 |
20 |
$57,101.40 |
$1,142.03 |
$2,500.00 |
$60,743.42 |
Option -Annuity Due
Quarter |
Beg.bal. |
Installment |
Interest |
End. Bal. |
1 |
$0.00 |
$2,500.00 |
$50.00 |
$2,550.00 |
2 |
$2,550.00 |
$2,500.00 |
$101.00 |
$5,151.00 |
3 |
$5,151.00 |
$2,500.00 |
$153.02 |
$7,804.02 |
4 |
$7,804.02 |
$2,500.00 |
$206.08 |
$10,510.10 |
5 |
$10,510.10 |
$2,500.00 |
$260.20 |
$13,270.30 |
6 |
$13,270.30 |
$2,500.00 |
$315.41 |
$16,085.71 |
7 |
$16,085.71 |
$2,500.00 |
$371.71 |
$18,957.42 |
8 |
$18,957.42 |
$2,500.00 |
$429.15 |
$21,886.57 |
9 |
$21,886.57 |
$2,500.00 |
$487.73 |
$24,874.30 |
10 |
$24,874.30 |
$2,500.00 |
$547.49 |
$27,921.79 |
11 |
$27,921.79 |
$2,500.00 |
$608.44 |
$31,030.22 |
12 |
$31,030.22 |
$2,500.00 |
$670.60 |
$34,200.83 |
13 |
$34,200.83 |
$2,500.00 |
$734.02 |
$37,434.85 |
14 |
$37,434.85 |
$2,500.00 |
$798.70 |
$40,733.54 |
15 |
$40,733.54 |
$2,500.00 |
$864.67 |
$44,098.21 |
16 |
$44,098.21 |
$2,500.00 |
$931.96 |
$47,530.18 |
17 |
$47,530.18 |
$2,500.00 |
$1,000.60 |
$51,030.78 |
18 |
$51,030.78 |
$2,500.00 |
$1,070.62 |
$54,601.40 |
19 |
$54,601.40 |
$2,500.00 |
$1,142.03 |
$58,243.42 |
20 |
$58,243.42 |
$2,500.00 |
$1,214.87 |
$61,958.29 |
Purchase 2:
Amount required in 3 year= $45000
Half yearly Interest rate =12/2= 6%
Sum of PVF at 6% for 6 half year = 4.9173
Sinking Fund payment per annum= $45000/4.9173 = $9151.36
1- Second Option (Annuity Due) is better than normal annuity because it gives more worth in 5 year.
2- Sinking Fund payment per annum= $45000/4.9173 = $9151.36
3- Interest under (Chosen) Due annuity = $61958.29-(2500×20) = $11958.29
Interest under Sinking fund= $45000-(9151.36×3) = $17545.90
4- Sinking Fund Option is better because it gives higher return