In: Accounting
On January 1, 2017, Aggie Security Systems purchased a new piece of high-tech security equipment. Aggie financed this purchase by making a cash down payment of $8,000 and agreeing to pay $60,000 at the end of 8 years. Assume interest is compounded annually. The equipment should be recorded on January 1, 2017, at what amount, assuming an appropriate interest rate of 5%. What is the carrying value of the note on December 31, 2018?
| 1) | ||||||||||
| Cost at which equipement should be recorded | $ 48,610.36 | |||||||||
| Working: | ||||||||||
| Equipment is recorded at its cost and cost of an assets is the | ||||||||||
| amount of money paid in cash and value of any kind. | ||||||||||
| In this case, partly paid in cash and partly financed by notes payable. | ||||||||||
| So, Cost of Asset will be amount of cash and value of in kind. | ||||||||||
| Value of Notes payable is always present value of cash flow from notes payable. | ||||||||||
| a. | Calculation of value of notes payable as of today: | |||||||||
| Value of Notes payable | = | Present Value | ||||||||
| = | Future Value x Present Value of 1 | |||||||||
| = | $ 60,000 | x | 0.67683936 | |||||||
| = | $ 40,610.36 | |||||||||
| Working: | ||||||||||
| Present Value of 1 | = | (1+i)^-n | Where, | |||||||
| = | (1+0.05)^-8 | i | 5% | |||||||
| = | 0.676839 | n | 8 | |||||||
| b. | Value of equipment | = | Cash paid + Present Value of Notes Paayble | |||||||
| = | $ 8,000.00 | + | $ 40,610.36 | |||||||
| = | $ 48,610.36 | |||||||||
| 2) | ||||||||||
| Carrying Value of note on December 31, 2018 | $ 44,772.92 | |||||||||
| Working: | ||||||||||
| Notes Amortization table: | ||||||||||
| Year | Beginning Carrying Value (1) | Interest for the Year (2) = (1) x 5% | Ending Carrying Value (1) +(2) | |||||||
| 1/1/2017 | $ 40,610.36 | |||||||||
| 12/31/2017 | $ 40,610.36 | $ 2,030.52 | $ 42,640.88 | |||||||
| 12/31/2018 | $ 42,640.88 | $ 2,132.04 | $ 44,772.92 | |||||||
| 12/31/2019 | $ 44,772.92 | $ 2,238.65 | $ 47,011.57 | |||||||
| 12/31/2020 | $ 47,011.57 | $ 2,350.58 | $ 49,362.15 | |||||||
| 12/31/2021 | $ 49,362.15 | $ 2,468.11 | $ 51,830.26 | |||||||
| 12/31/2022 | $ 51,830.26 | $ 2,591.51 | $ 54,421.77 | |||||||
| 12/31/2023 | $ 54,421.77 | $ 2,721.09 | $ 57,142.86 | |||||||
| 12/31/2024 | $ 57,142.86 | $ 2,857.14 | $ 60,000.00 | |||||||