In: Accounting
Six Company sells an asset with a $1 million fair value to A Company. A Company agrees to make six equal payments, each to be paid one year apart, commencing on the date of sale. The payments include principal and 6% annual interest. What is the amount of the annual payments? can u solve this using the financial calculator method (pv= fv= n= pmt= )and is this gonna be using beginning mode (annuity due) or end mode (ordinary annuity)
| 
 Sale value  | 
 1000000  | 
| 
 Annuity calculation  | 
|
| 
 Year  | 
 PVIF @ 6%  | 
| 
 0  | 
 1  | 
| 
 1  | 
 0.943396226  | 
| 
 2  | 
 0.88999644  | 
| 
 3  | 
 0.839619283  | 
| 
 4  | 
 0.792093663  | 
| 
 5  | 
 0.747258173  | 
| 
 Annuity factor  | 
 5.212363786  | 
| 
 PVAF(6%, n=6, Years=5)=5.21236  | 
|
| 
 PVAF=Present value annuity factor  | 
|
| 
 Annual payments=Sale value of asset/Annuity factor  | 
|
| 
 191851.5363  | 
|
| 
 For your better understanding amortization table has been drawn  | 
| Year | Opening balance | Interest @6% | Installement amount | Principal amount | Closing balance | 
| 0 | 10,00,000.00 | - | 1,91,851.54 | 1,91,851.54 | 8,08,148.46 | 
| 1 | 8,08,148.46 | 48,488.91 | 1,91,851.54 | 1,43,362.63 | 6,64,785.84 | 
| 2 | 6,64,785.84 | 39,887.15 | 1,91,851.54 | 1,51,964.39 | 5,12,821.45 | 
| 3 | 5,12,821.45 | 30,769.29 | 1,91,851.54 | 1,61,082.25 | 3,51,739.20 | 
| 4 | 3,51,739.20 | 21,104.35 | 1,91,851.54 | 1,70,747.18 | 1,80,992.02 | 
| 5 | 1,80,992.02 | 10,859.52 | 1,91,851.54 | 1,80,992.02 | - | 
| Note: In the given case, first payment is made at the time of sale and every payment is made at the interval of one year. Hence, First payment is made at year 0 and there will not be any interest. |