Managerial accounting

expanded_pv_tables.xlsx

Sheet1

Present Value of $1
Periods	25%	26%	27%	28%	29%	30%	35%	40%	45%	50%	55%	60%
1	0.800	0.794	0.787	0.781	0.775	0.769	0.741	0.714	0.690	0.667	0.645	0.625
2	0.640	0.630	0.620	0.610	0.601	0.592	0.549	0.510	0.476	0.444	0.416	0.391
3	0.512	0.500	0.488	0.477	0.466	0.455	0.406	0.364	0.328	0.296	0.269	0.244
4	0.410	0.397	0.384	0.373	0.361	0.350	0.301	0.260	0.226	0.198	0.173	0.153
5	0.328	0.315	0.303	0.291	0.280	0.269	0.223	0.186	0.156	0.132	0.112	0.095
Present Value of an Annuity of $1 in Arrears $1
Periods	25%	26%	27%	28%	29%	30%	35%	40%	45%	50%	55%	60%
1	0.800	0.794	0.787	0.781	0.775	0.769	0.741	0.714	0.690	0.667	0.645	0.625
2	1.440	1.424	1.407	1.392	1.376	1.361	1.289	1.224	1.165	1.111	1.061	1.016
3	1.952	1.923	1.896	1.868	1.842	1.816	1.696	1.589	1.493	1.407	1.330	1.260
4	2.362	2.320	2.280	2.241	2.203	2.166	1.997	1.849	1.720	1.605	1.503	1.412
5	2.689	2.635	2.583	2.532	2.483	2.436	2.220	2.035	1.876	1.737	1.615	1.508