# PV and Interest Calculation Help

#### VegaOne16

##### New Member
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.

### 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

Replies
1
Views
299
Replies
0
Views
187
Replies
0
Views
152
Replies
0
Views
175
Replies
6
Views
754

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