---------- Forwarded message ----------
From: Jorge Saguinsin <holygardens.groupnew@gmail.com>
Date: Sun, Nov 19, 2017 at 8:49 PM
Subject: Re accounting exam
To: Majorem Investor <majorem.lending@gmail.com>
From: Jorge Saguinsin <holygardens.groupnew@gmail.com>
Date: Sun, Nov 19, 2017 at 8:49 PM
Subject: Re accounting exam
To: Majorem Investor <majorem.lending@gmail.com>
To: All Accounting staff
These are my comments on your exams;
1. Thank you for striving to apply xls on your accounting exam
2. It was better if you did the following
1. The journal entries were spread out into a trial balance/per account
with debit and credit No no need for T accounts
2. E.g.
Journal Entries Cash She FFE
DR CR DR CR DR CR
1. Investment 10,000 10,000
2 Buy garapon etc 3,000 3,000
You can summarize this trial balance and harvest all the accounts for IS, Cash Flow etc. Again we are repeating that the cash account is the Cash Flow statement
You can make this neater by having all the Balance Sheet Accounts together and Income Statement together
3. We can hack make the short cut the Excel file, by creating a cell or computing quickly: (For RGP)
a. Copy the total of the NLP from your excel
b. Create new column
Enter formula:
Say row P x 40%
Say row Q x 50%
3. Compute RGP total
NLP x Developers Share - CGS
P8,750 for lawn
P35,000 for SSN
P105,000 for GE
4. Divide by 60
5. Subtract from MA the CGS per month if all the rows are all minimum MA
--
PAGSASANAY SA TAGUMPAY (Training for Success)
SETTING THE STANDARDS IN INTERMENT SERVICE
Innovation creates more wealth and more customers
Jorge U. Saguinsin
Be a BIDDA now
RRURAC (Read, Reflect, Understand, Realize Act, Check)
Please visit the following sites:
Notice: This email address is a private property of Holy Gardens Group and its contents are private and confidential. Its contents and attachment may not be copied nor forwarded to parties other than the ones intended to, nor can the contents be used other than the original intent You are advised to delete the message you received if in case it may have been wrongly sent to your good office
PAGSASANAY SA TAGUMPAY (Training for Success)
SETTING THE STANDARDS IN INTERMENT SERVICE
Innovation creates more wealth and more customers
Jorge U. Saguinsin
Be a BIDDA now
RRURAC (Read, Reflect, Understand, Realize Act, Check)
Please visit the following sites:
Notice: This email address is a private property of Holy Gardens Group and its contents are private and confidential. Its contents and attachment may not be copied nor forwarded to parties other than the ones intended to, nor can the contents be used other than the original intent You are advised to delete the message you received if in case it may have been wrongly sent to your good office
