PV and Interest Calculation Help

VegaOne16

New Member
Joined
Sep 6, 2009
Messages
18
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:

PeriodPeriod DaysCash OutflowStraight line ExpensePV CashInterest ExpAsset BalanceLiability BalanceBegin DateEnd Date
11,467.6011,467.60
1/1/2020

<tbody>
</tbody>
1/26/2020

<tbody>
</tbody>
1261,000.00852.461,000.0074.75
10,689.89

<tbody>
</tbody>
10,542.35

<tbody>
</tbody>
1/27/2020

<tbody>
</tbody>
2/23/2020

<tbody>
</tbody>
2281,000.00918.03991.5574.78
9,846.64

<tbody>
</tbody>
9,617.13

<tbody>
</tbody>
2/24/2020

<tbody>
</tbody>
3/22/2020

<tbody>
</tbody>
3281,000.00918.03983.7167.94
8,996.55

<tbody>
</tbody>
8,685.07

<tbody>
</tbody>
3/23/2020

<tbody>
</tbody>
4/19/2020

<tbody>
</tbody>
4281,000.00918.03975.4061.59
8,140.11

<tbody>
</tbody>
7,746.66

<tbody>
</tbody>
4/20/2020

<tbody>
</tbody>
5/17/2020

<tbody>
</tbody>
..............................
TOTALTOTAL
TOTALTOTALTOTAL
36612,00012,00011,467.60532.40

<tbody>
</tbody>

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

Thank you for your consideration.
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Watch MrExcel Video

Forum statistics

Threads
1,108,620
Messages
5,523,944
Members
409,543
Latest member
LaMaqu1na

This Week's Hot Topics

Top