PV and Interest Calculation Help

[VegaOne16]

Hello,

A spreadsheet I recently inherited has hard coded numbers, I was hoping someone could help me with the formulas to recompute a couple columns (PV Cash & Interest Exp) that I can't seem to re-create.

Discount rate is 10%, term is 1/1/2020 - 12/31/2020, it's on a 13 period fiscal year.

Here is a snapshot of the data:

Period	Period Days	Cash Outflow	Straight line Expense	PV Cash	Interest Exp	Asset Balance	Liability Balance	Begin Date	End Date
						11,467.60	11,467.60	1/1/2020 <tbody> </tbody>	1/26/2020 <tbody> </tbody>
1	26	1,000.00	852.46	1,000.00	74.75	10,689.89 <tbody> </tbody>	10,542.35 <tbody> </tbody>	1/27/2020 <tbody> </tbody>	2/23/2020 <tbody> </tbody>
2	28	1,000.00	918.03	991.55	74.78	9,846.64 <tbody> </tbody>	9,617.13 <tbody> </tbody>	2/24/2020 <tbody> </tbody>	3/22/2020 <tbody> </tbody>
3	28	1,000.00	918.03	983.71	67.94	8,996.55 <tbody> </tbody>	8,685.07 <tbody> </tbody>	3/23/2020 <tbody> </tbody>	4/19/2020 <tbody> </tbody>
4	28	1,000.00	918.03	975.40	61.59	8,140.11 <tbody> </tbody>	7,746.66 <tbody> </tbody>	4/20/2020 <tbody> </tbody>	5/17/2020 <tbody> </tbody>
...	...	...	...	...	...	...	...	...	...
	TOTAL	TOTAL	TOTAL	TOTAL	TOTAL
	366	12,000	12,000	11,467.60	532.40

<tbody>
</tbody>

Will forever be in your debt if you can assist with the formulas.

Thank you for your consideration.