Question: table [ [ Model: DCF using Annual Financing Flows ] , [ Table 5 - Panels Financing, 9 / 2 5 / 2 4

\table[[Model: DCF using Annual Financing Flows],[Table 5- Panels Financing,9/25/24,12/31/24,12/31/25,12/31/26,12/31/27,12/31/28,12/31/29,12/31/30,12/31/31,12/31/32,12/31/33,12/31/34,12/31/35,12/31/36,12/31/37,12/31/38],[Starting principal,$0.00,$360,000.00,$360,000.00,$360,000.00,$360,000.00,$360,000.00,$360,000.00,$360,000.00,$360,000.00,$360,000.00,$360,000.00,$360,000.00,$360,000.00,$360,000.00,$360,000.00,$360,000.00],[Interest,$0.00,$0.00,$15,300.00,$15,300.00,$15,300.00,$15,300.00,$15,300.00,$15,300.00,$15,300.00,$15,300.00,$15,300.00,$15,300.00,$15,300.00,$15,300.00,$15,300.00,$15,300.00],[Interest tax shield,$0.00,$0.00,$3,213.00,$3,213.00,$3,213.00,$3,213.00,$3,213.00,$3,213.00,$3,213.00,$3,213.00,$3,213.00,$3,213.00,$3,213.00,$3,213.00,$3,213.00,$3,213.00],[Principal repayment,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,$360,000.00],[Ending principal,$360,000.00,$360,000.00,$360,000.00,$360,000.00,$360,000.00,$360,000.00,$360,000.00,$360,000.00,$360,000.00,$360,000.00,$360,000.00,$360,000.00,$360,000.00,$360,000.00,$360,000.00,$0.00],[Net panels financing flows,$360,000.00,$0.00,$ $12,087.00,- $12,087.00,- $12,087.00,- $12,087.00,$ $12,087.00,$ $12,087.00,$ $12,087.00,- $12,087.00,- $12,087.00,- $12,087.00,- $12,087.00,- $12,087.00,$ $12,087.00,- $372,087.00],[NPV panels financing,$37,065.60,,,,,,,,,,,,,,,],[Table 6- Batteries Financing,9/25/24,12/31/24,12/31/25,12/31/26,12/31/27,12/31/28,12/31/29,12/31/30,12/31/31,12/31/32,12/31/33,12/31/34,12/31/35,12/31/36,12/31/37,12/31/38],[Starting principal,$0.00,$ 180,000.00,$180,000.00,$167,574.69,$154,155.36,$139,662.48,$124,010.17,$107,105.68,$88,848.82,$69,131.42,$47,836.63,$24,838.25,$0.00,$0.00,$0.00,$0.00],[Interest,$0.00,$0.00,$14,400.00,$13,405.98,$12,332.43,$11,173.00,$9,920.81,$8,568.45,$7,107.91,$5,530.51,$3,826.93,$1,987.06,$0.00,$0.00,$0.00,$0.00],[Interest tax shield,$0.00,$0.00,$3,024.00,$2,815.25,$2,589.81,$2,346.33,$2,083.37,$1,799.38,$1,492.66,$1,161.41,$803.66,$417.28,$0.00,$0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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 General Management Questions!