Question: how to get the cash flow table, discount rate table, PV table, and accumulated cash flow table in excel? year 0 1 2 3 4

how to get the cash flow table, discount rate table, PV table, and accumulated cash flow table in excel?


year 0 1 2 3 4 5 6 7 K K K 

year 0 1 2 3 4 5 6 7 K K K K K K K K TC TR K 1,502,400,000.00 K 1,502,400,000.00 10,139,700,000.00 801,600,000.00 834,000,000.00 K 1,502,400,000.00 866,400,000.00 1,502,400,000.00 920,400,000.00 K 1,502,400,000.00 952,800,000.00 K 1,502,400,000.00 1,006,800,000.00 K 1,502,400,000.00 1,039,200,000.00 K 1,502,400,000.00 Cash flow Discount rate 10% PV accumulated cash flow

Step by Step Solution

3.38 Rating (151 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To create a cash flow table discount rate table present value PV table and accumulated cash flow tab... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!