Scribd
Upload
31 views2 pages

Financial Functions Excel

The document outlines a financial schedule detailing period payments, interest, principal, and outstanding liabilities over five periods. It includes calculations for effective interest and amortization of discount, showing how the carrying amount changes over time. The final period indicates that the outstanding liability is fully paid off.

Uploaded by

Britney Shin Tero
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
31 views2 pages

Financial Functions Excel

The document outlines a financial schedule detailing period payments, interest, principal, and outstanding liabilities over five periods. It includes calculations for effective interest and amortization of discount, showing how the carrying amount changes over time. The final period indicates that the outstanding liability is fully paid off.

Uploaded by

Britney Shin Tero
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Period Payment (₱)

Interest (₱)Principal
Outstanding
(₱) Liability (₱)
1 1000000 0 1000000 4000000
2 1000000 80000 920000 3080000
3 1000000 67200 932800 2147200
4 1000000 53760 946240 1200960
5 1000000 39661 960339 0
Period Interest Payment (₱)Effective InterestAmortization
(₱) of Discount
Carrying
(₱) Amount (₱)
1 40000 48227 8227 972767
2 40000 48438 8438 981205
3 40000 48652 8652 989857
4 40000 48869 8869 998726

You might also like