PLEASE ANSWER THEM ALL CORRECTLY FOR AN UPVOTE AND POSITIVE RATINGS. THANK YOU. WRITTEN WORK # 15u mco sp heActivity 1. Spread my SalaryDirection: The data below shows the partial salary of employees. Complete the tableto showtheir annual, monthly, semi/weekly and bi-weekly salary. Use excel. (Show theformula)WeeklySalarySemi-Bi-MonthlySalaryNameAnnualSalaryMonthlyweeklyMaritesP11,538P20,000JaniceLynP5,000LeoP40,000shoilFlorP96,000Activity 2. Spread my SalaryDirection: Using the spreadsheet, compute for the corresponding contributions of thefollowingemployees. Compute also their total deduction. (Show the formula)EFH.AINCOMEDEDUCTIONSNameBasic MonthlySSS PHILHEALTH PAGIBIGTAXTotalDeductionsSalary4%1.50%2%12%4 Magpayo, Lyn5 Quiambao, Jhaz6 Cruz, Russel7 Garcia, Geth8 Niedao, Maine9 Mendoza, Rhoda0 Mallari, Tes1 Santos, Paula2 Urbano, JaneenP20,000.00P25,000.00P30,000.00P40,000.00P45,000.00P50,000.00P55,000.00P60,000.00P65,000.0023

Hi, there, Thanks for posting the question. As per our Q&A honour code, we must answer the first…

Activity 1. Spread my Salary Direction: The data below shows the partial salary of employees. Complete the table to showtheir annual, monthly, semi/weekly and bi-weekly salary. Use excel. (Show the formula) Weekly Salary Bi- Monthly Salary Name Annual Semi- Salary Monthly weekly Marites P11,538 P20,000 Janice Lyn P5,000 Leo P40,000 Flor P96,000

Activity 1. Spread my Salary Direction: The data below shows the partial salary of employees. Complete the table to showtheir annual, monthly, semi/weekly and bi-weekly salary. Use excel. (Show the formula) Weekly Salary Bi- Monthly Salary Name Annual Semi- Salary Monthly weekly Marites P11,538 P20,000 Janice Lyn P5,000 Leo P40,000 Flor P96,000

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Explain sensitivity analysis and how is sensitivity measured. Give examples?
show in excel form
Ocak Uçan Yağlar Sanayi A.Ş. He bought 6 automatic filling machines and paid a total of 600,000 liras for them. The depreciation life of filling machines is 5 years. In this situation a) If the ordinary depreciation method is applied, what is the depreciation amount to be allocated according to the years? 4. What will be the book value at the end of the year? b) If the rapid depreciation method is applied, what is the depreciation amount to be allocated over the years? 4. What will be the book value at the end of the year?
List and describe the components of a SWOT analysis.
Can you please provide me some examples or practice problems to calculate allocation rate?
Feedback from the control function helps managers compare actual results with planned results and take corrective actions. True or False True False
Consider an organization of your choosing that might be creating a survey for a product or service. Write two example questions that you would use to interpret descriptive statistics and two example questions that you would use to interpret inferential statistics.
Give an example of a "rate fence". Include a brief description of how it works and a brief comment on your perception of its effectiveness and any other relevant/brief thoughts.
Compare and contrast a between-groups design and a within-subjects design. What information about variables, levels, and design should you keep in mind in order to choose an appropriate statistic?
Respond to the following in a discussion post: Define a balanced scorecard. Discuss at least three critical measures you would incorporate in your scorecard and discuss why these elements are necessary. Be sure to respond to at least one of your classmates posts.
Draw out a trial balance using the above trasnsactions . Thank you .
Hi can you show how to input in excel using the pmt formula thank you so much