Class Notes (1,035,351)
US (406,599)
USF (767)
Lecture 6

# ACG 3103 Lecture 6: INT ACT I NOTES PAYABLES Formula view

1 pages98 viewsFall 2014

Department
Accounting
Course Code
ACG 3103
Professor
T O T H
Lecture
6

This preview shows half of the first page. to view the full 1 pages of the document.
Int Accounting I
Excel Project
a. Date Cash (dr.) N/R (cr) Cash (dr) Int. Rev. (cr) Disc. On N/R. (dr) PV
=SUM(100000*0.67684)+(4000*6.46321)
40358 0 =SUM(0.04*100000) =SUM(0.05*G3) =SUM(E4-D4) =SUM(G3+F4)
40542 0 =SUM(0.04*100000) =SUM(0.05*G4) =SUM(E5-D5) =SUM(G4+F5)
40723 0 =SUM(0.04*100000) =SUM(0.05*G5) =SUM(E6-D6) =SUM(G5+F6)
40907 0 =SUM(0.04*100000) =SUM(0.05*G6) =SUM(E7-D7) =SUM(G6+F7)
41089 0 =SUM(0.04*100000) =SUM(0.05*G7) =SUM(E8-D8) =SUM(G7+F8)
41273 0 =SUM(0.04*100000) =SUM(0.05*G8) =SUM(E9-D9) =SUM(G8+F9)
41454 0 =SUM(0.04*100000) =SUM(0.05*G9) =SUM(E10-D10) =SUM(G9+F10)
41638 100000 =SUM(0.04*100000) =SUM(0.05*G10) =SUM(E11-D11) 0
a. Date Cash (dr.) N/R (cr) Cash (dr) Int. Rev. (cr) Prem. On N/R. (cr) PV
=SUM(100000*0.78941)+(4000*7.01969)
40359 0 =SUM(0.04*100000) =SUM(0.03*G20) =SUM(D21-E21) =SUM(G20-F21)
40543 0 =SUM(0.04*100000) =SUM(0.03*G21) =SUM(D22-E22) =SUM(G21-F22)
40724 0 =SUM(0.04*100000) =SUM(0.03*G22) =SUM(D23-E23) =SUM(G22-F23)
40908 0 =SUM(0.04*100000) =SUM(0.03*G23) =SUM(D24-E24) =SUM(G23-F24)
41090 0 =SUM(0.04*100000) =SUM(0.03*G24) =SUM(D25-E25) =SUM(G24-F25)
41274 0 =SUM(0.04*100000) =SUM(0.03*G25) =SUM(D26-E26) =SUM(G25-F26)
41455 0 =SUM(0.04*100000) =SUM(0.03*G26) =SUM(D27-E27) =SUM(G26-F27)
41639 100000 =SUM(0.04*100000) =SUM(0.03*G27) =SUM(D28-E28) 0
Note 1:
Note 2: