Direction: Act as an accountant. Enter the given data in excel and compute for the gross income, the exact amount of partial deductions, total deductions, and net pay.Deductions:SSS = 4%Philhealth = 1.50%Pagibig = 2%Tax = 12%(Please show the formula in excel) INCOMENameBasic MonthlySalarySSSAllowance Gross Income4%4 Magpayo, Lyn5 Quiambao, Jhaz6 Cruz, Runsel7 Garcia, Getha Niedao, Maine9 Mendoza, Rhoda10 Mallari, Tes11 Santon. Paula12 Urbano, JannenP20,000.00 P2,000.00P25,000.00 P2,000.00P30,000.00 P2,000.00P40,000.00 P2,000.00P450,000.00 P2,000.00P50,000.00 P2,000.00P55,000.00 P2,000.00P60,000.00 P2,000.00P65,000.00 P2.000.00 INCOMEDEDUCTIONSBaale MunthlySalaryNameS5s PHILHEALTH PAGIGTAXNET PAYAllwnce Gre IncomeTutalDeduntiene2%12%6 Cr, her7Garcia, GiethNda, MaineMenidann, thodato Mallari, Tes1 Sasten, Paula12 trtann laeenP20,000.00 P2.000 00Pa5,000.00 P2.000.00P0,000.00 P2000.00P0,000.00 P2.000.00PAS0,000.00 P2000.00PO0,000.00 P2000.00P000.00P2.000.00P0.000.0ol 2.000.0X0P5,000.00 P2.000.00

Note :All deductions are calculated on Gross income

Direction: Act as an accountant. Enter the given data in excel and compute for the gross income, the exact amount of partial deductions, total deductions, and net pay. Deductions: SSS = 4% Philhealth = 1.50% Pagibig = 2% Tax = 12% (Please show the formula in excel)

Direction: Act as an accountant. Enter the given data in excel and compute for the gross income, the exact amount of partial deductions, total deductions, and net pay. Deductions: SSS = 4% Philhealth = 1.50% Pagibig = 2% Tax = 12% (Please show the formula in excel)

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Q: If E-P28,091.16 and N = P11,213.00, what is the value of D? Note: E= Total Earnings D- Deduction N=…

A: Formula used : Net pay = Total Earnings - Deductions

Q: Select the best order for the following items in the income statement: 1. Income from continuing…

Q: A) Calculate the total Current Assets, Total Assets, Total Liabilities and Equity, Gross profit,…

A: The common-sized financial statements are statements where the items are represented in the form of…

Q: Pronghorn Enterprises Ltd., a private company following ASPE earned accounting income before taxes…

A: Calculation of current income tax expenseParticulars$Net profit before tax as per accounts $…

Q: Help me make an income statement

A: Financial Statements: Financial Statements represent a formal record of the financial activities of…

Q: The revenue recognition principle dictates that revenue be recognized in the accounting period…

A: The revenuerve recognition principle states that every business organization should recognize the…

Q: indicate whether the statement describes a multiple-step income statement or asingle-step income…

Q: If the 'bottom line' on the Income Statement section of a worksheet shows a net income, the amount…

A: The objective of the question is to understand the correct placement of net income in the worksheet…

Q: d. Unearned Income 2. Which of the following is an element of a statement of comprehensive income?…

A: (1.) Revenues is an element of a statement of comprehensive income. Therefore, the option (b)…

Q: It is added to income received to determine the total income for the year that is recorded under the…

A: Net income: It can be defined as the excess of a company's sales revenue over the expenses incurred…

Q: Insurance expense Office expense Supplies expense Real estate and payroll taxes Depreciation expense…

A: Expenses are those cash outflows which is done for earning revenue. It is part of Income Statement.…

Q: Academic Dishonesty Investigations Ltd. operates a plaglarism detection service for unlversitles and…

A: Adjusting journal entry: At year-end when the company finalizes its accounts then any unrecognized…

Q: Use the Income Summary T-Account and words in the word bank to fill in the statements below. 1. The…

A: Income statement means a summary of revenue and expenditure of the organisation during a year and…

Q: List and describe the various formats available for the preparation of an Income Statement.

A: Income statement: It is a financial statement that calculates the net income generated by a…

Q: Briefly describe this income statement in one sentence.

A: Introduction:- Income statement shows company's income and expenses over a period of time. Formula…

Q: In a sheet of paper, write TRUE if the statement is correct and FALSE if the statement is incorrect.…

A: I am answering the first 3 sub-parts of the question as per bartleby guidelines. Please re-submit…

Q: Required information [The following information applies to the questions displayed below.] Selected…

A: Income Statement - An income Statement is a financial statement that includes Revenue earned and…

Q: Income Statement ($K) Period Ending Total Revenue Cost of Revenue Gross Profit SG&A Non Recurring…

A: Answer Formula SG&A / Total Revenue SG&A / Total Revenue SG&A / Total Revenue…

Q: In the Excel, or spreadshneet, approach to recording financial transactions, the revenues and…

A: Explanation: The Spreadsheet cannot indicate the approach to recording financial transactions as the…

Q: Classify each of the following items as revenues (R), expenses (EX), or withdrawals (W). Wages…

A: Financial Accounting: It refers to the process of recording the financial transactions of the…

Q: The formula for Adjusted Gross Income (AGI) is: Gross Income - Exclusions Gross Income - Deductions…

A: Adjusted Gross Income (AGI) is a key financial metric used in the United States to determine an…

Q: True or False: The amount-owed component of the FICO score includes the proportion of credit…

A: Below is the correct answer

Q: 7. When the debit column total of the income statement section of the work sheet is greater than the…

A: Income statement is the financial statement that records the income and expenses of the business.…

Q: Required: 1. Compute cost of goods sold for each of the two items separately using the FIFO and LIFO…

A: Cost of Sold Under FIFO A Rate COST B Rate COST Total items sold on 28 April 420 420…

Q: Matching Concept: Expenses & Revenues How does sales salaries expense directly relate to revenue?…

A: The sum of all wages paid to workers by a business, including base pay and any fresh gratuities…

Q: Fill in the blank with these terms : long term, expense, balance sheet, Stockholder's equity,…

A: Solution: 1. Revenues are monies an organization received in exchange for goods and Service it…

Q: The times interest earned ratio is computed as Oa. Income Before Income Tax + Interest Expense Ob.…

A: Times interest earned ratio depicts the ability of an entity to service its interest expense. It…

Q: Which of the following journals would correctly post an adjustment for deferred (prepaid) income?…

A: The journal entries are prepared to keep the record of day to day transactions of the business on…

Q: On October 5, 2023, Diamond in the Marigold Recruiting Group Inc.'s board of directors decided to…

A: Total income included in income of blue division = Net income before tax + Assets written off

Q: After completing the preparation, the necessarg credit adjustments are made to adjust the balances…

A: At the end of accounting period, every business has to make some adjusting entries. These adjustment…

Q: Which account is least likely to appear in an adjustingjournal entry?a. Cashb. Interest Receivablec.…

A: Adjusting entries: Adjusting entries are those entries which are recorded at the end of the year,…

Q: Describe the basic format of an income statement, listing all its sections.

A: Income statement Income statement is refer as the statement which summarizes the revenue and…

Q: HOMEWORK Please tell me if the following are found Assets, Liabilities, Equity, Revenue, or Expense…

A: Type of accounts:

Q: Identify the financial statement(s) that the following items appear on. a)interest expense, b)…

A: The Financial Statements consists of: 1- Profit & Loss Account (Income Statement) 2- Balance…

Q: recorded under the accrual basis of accounting A. deferred income - end B. prepaid expense - beg C.…

A: (c) Accrued income-beg , is added to income received to determine the total income for the yearthat…

Q: iscuss FIVE income statement items (revenue and/or expenses) that can be manipulated, and how they…

A: Manipulating income statement items to increase earnings is an unethical practice known as earnings…

Q: Which of the following expenses is usually listed last on the income statement? a. Advertising…

A: The income statement is one of the financial statements of the business. It tells about the…

Q: Sales Direct materials Direct labor overhead-variable Manufacturing Manufacturing overhead-fixed…

A: Variable costs are costs that vary with the change in the level of output whereas fixed costs are…

Q: You have established your performance materiality for accounts payable and revenue; now you must…

A: Materiality is a concept used in accounting and auditing to determine the significance or importance…

Q: Preparing an income statement) Prepare an income statement and a common-sized income statement from…

A: The income statement is one of the financial statements of the business. It records the revenue and…

Q: 32.In a work sheet, net income is entered in the following columns: a. Income Statement (Dr) and…

A: The worksheet represents the different statement such as adjuted trial balance, income statement and…

Question

INCOME
Name
Basic Monthly
Salary
SSS
Allowance Gross Income
4%
4 Magpayo, Lyn
5 Quiambao, Jhaz
6 Cruz, Runsel
7 Garcia, Geth
a Niedao, Maine
9 Mendoza, Rhoda
10 Mallari, Tes
11 Santon. Paula
12 Urbano, Jannen
P20,000.00 P2,000.00
P25,000.00 P2,000.00
P30,000.00 P2,000.00
P40,000.00 P2,000.00
P450,000.00 P2,000.00
P50,000.00 P2,000.00
P55,000.00 P2,000.00
P60,000.00 P2,000.00
P65,000.00 P2.000.00

INCOME
DEDUCTIONS
Baale Munthly
Salary
Name
S5s PHILHEALTH PAGIG
TAX
NET PAY
Allwnce Gre Income
Tutal
Deduntiene
2%
12%
6 Cr, her
7Garcia, Gieth
Nda, Maine
Menidann, thoda
to Mallari, Tes
1 Sasten, Paula
12 trtann laeen
P20,000.00 P2.000 00
Pa5,000.00 P2.000.00
P0,000.00 P2000.00
P0,000.00 P2.000.00
PAS0,000.00 P2000.00
PO0,000.00 P2000.00
P000.00P2.000.00
P0.000.0ol 2.000.0X0
P5,000.00 P2.000.00

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

Joseph Bright lists the following transactions for the period ended 30 September 2017. Classify EACH item as follows: i. Write either capital or revenue in the expenditure type column to indicate the type of expenditure involved or EACH item. ii. Insert a-check mark (√) in the appropriate column to indicate whether the item is reported-in the Statement of profit or loss or in the Statement of financial position. The first one is done as an example. Description CLASSIFICATION OF EXPENDITURE Expenditure Type Statement where item should be reported Statement of Profit Statement of Example Wages of the computer operators 1 Cost of customizing software for use in business 2 Installing thief detection equipment 3 Cost of paper used for printing receipts during the year 4 Cost of toner used by the computer printer 5 Cost of adding extra memory to the compute or loss Revenue financial position
item#2
sales tax is collected from customers and paid to the a. board of equalization b. contract documents c. net profit for the year d. current and long term
Identifying and Classifying Financial Statement Items For each of the following items, indicate whether they would be reported in the balance sheet (B) or income statement (1). (a) Machinery (b) Supplies expense (c) Inventories (d) Sales (e) Common stock (f) Factory buildings (g) Receivables (h) Taxes payable (i) Taxes expense (i) Cost of goods sold (k) Long-term debt (1) Treasury stock ◆ ◆ ◆ ♦ ♦ ◆ ◆ ♦ ♦
(a) Describe the detail of the transaction being performed in the following screen. (b) Give the journal entry that MYOB made as a result of the transaction in part (a) (Note: account numbers are not required, just use account names.)
Define each of the following terms:a. Annual report; balance sheet; income statement
Indicate if the following transaction from Torte Baking Company increases or decreases assets, liabilities, equity, revenue, expense, and net income. The pattern of the + and - must adhere to the balance sheet equation. Show the impact of revenue and expense on both net income and equity. If there is a + and - within one category (e.g., assets for transaction 2), then list the accounts that go up and down. Transaction (26) Recognize tax expense that will be paid later. Assets ["", "", ""] Liabilities ["", "", ""] Equity ["", "", ""] Revenue ["", "", ""] Expense ["", "", ""] Net Income ["", "", ""]
The adjusting entry to record the accrual of income tax expense includes a: O A. credit to Income Tax Expense. B. debit to Income Tax Payable. C. credit to Accounts Payable. D. credit to Income Tax Payable.
Fill in the blank Add up all Earned Income from all and "Wages, salaries, tips, etc.". Input all Unearned Income amounts from your Sum all Earned & Unearned Income to determine Total Income on Form 1040. then input this figure for
The amount found in the Income Statement debit column on the worksheet for Income Summary is the: A.ending inventory. B.beginning inventory. C.total amount of expenses. D.total amount of revenues.
On a multiple step income statement, the account interest expense would be located under A) Net sales B) COGS C) Other Revenues and expenses
Five account classifications are shown as column headings in the table below. For each accountclassification, indicate the manner in which increases and decreases are recorded (i.e., by debits orby credits).Owners’Revenue Expenses Assets Liabilities EquityIncreases recorded by:Decreases recorded by: