School

University of South Florida
Department

Accounting

Course Code

ACG 3103

Professor

T O T H

Lecture

6

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:

Over 90% improved by at least one letter grade.

OneClass has been such a huge help in my studies at UofT especially since I am a transfer student. OneClass is the study buddy I never had before and definitely gives me the extra push to get from a B to an A!

Leah â€” University of Toronto

Balancing social life With academics can be difficult, that is why I'm so glad that OneClass is out there where I can find the top notes for all of my classes. Now I can be the all-star student I want to be.

Saarim â€” University of Michigan

As a college student living on a college budget, I love how easy it is to earn gift cards just by submitting my notes.

Jenna â€” University of Wisconsin

OneClass has allowed me to catch up with my most difficult course! #lifesaver

Anne â€” University of California

Join OneClass

Access over 10 million pages of study

documents for 1.3 million courses.

Sign up

Join to view

OR

By registering, I agree to the
Terms
and
Privacy Policies

Already have an account?
Log in

Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.