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

Related questions

Q: Fill out the percentages column and the yellow and green bottom. Need verification. Show…

A: Income statement is the financial statement prepared for analyzing the profitability of a company.

Q: How would you find FW with excel functions?

A: MARR is 20% EOY Cash Flow 0 $ -70,000.00 1 $ 20,000.00 2…

Q: Compute interrater reliability by running a paired t test for the essay score 1 with the essayscore…

A: To compute the interrater reliability between essay score 1 and essay score 2, we can run a paired…

Q: Distinguish between program service expenses and supporting service expenses.

A: A nonprofit organization’s expenses can be classified into two types, they are expenses for program…

Q: In your own words, describe ETF’s historical performance. Explain whether it has successfully beaten…

A: An ETF is a collection of assets whose shares are traded on a stock market. They combine the…

Q: what excel formula feature would you use

A: Information Provided: Price of bond = $1135.90 Years to Maturity = 10 Annual Yield to Maturity = 8%…

Q: 2.3-2.4 (Excel): You have been offered a unique investment opportunity. If you invest $1 million at…

A: Net present value of investment is the difference between present value of inflows and outflows.…

Q: Write the six of the key input variables. of sensitivity analysis?

A: Sensitivity is a change in volume, sales, cost, so on. The 6 of the input variables of sensitivity…

Q: Describe the benefits of benchmarking.

A: Benchmarking is a way to measure something in corporate environment, it is also used to promote…

Q: 6, calculate the net present value (NPV) and indicate whether to accept or reject the machine.

A: Calculation of NPV using Excel Function: Excel Spreadsheet:

Q: Compute Cohen’s kappa to assess reliability using Rater 1 and Rater 2. Interpret theoutput as in…

A: Suppose we have the following contingency table based on their assessments: Rater 2: YesRater 2: No…

Q: A B C D E A B C D E Type of Quality Characteristic Consistency Type of Quality Characteristic #…

A: A. It can be seen that an unit of Chocolate Chip Cookies is valued at $9.56. However, the same…

Q: uss how to choose the appropriate benchmark for performance e

A: Choosing appropriate benchmark is very important for evaluation of performance of the portfolio.

Q: Summarizing data to understand what has happened is what type of analytics? Multiple Choice…

A: Data analytics is one of the important aspect used by companies to make the data useful and…

Q: Can you show how the NPV for project B was calculated. Still need to understand how answer was…

A: Net present value is the net value added by a certain decision. It is the difference between the…

Q: If you believe IRR is the most reliable tool, please provide some additional data to support that…

A: IRR can be defined as the discount rate at which the present value of all future cash flows (or…

Q: What are the Microsoft Excel formulaues used to input these? Is there a way to show each formula for…

Q: Question 2 Listen Which linear regression equation matches the given data sets? Use your TI-84+…

A: To determine which linear regression equation matches each given data set, we need to calculate the…

Q: Graph the data and comment on whether or not there are potential outliers.

A: This question's fundamental idea entails:Recognizing cost behavior, in particular the possibility…

Q: Would it be possible to show this in excel?

A: A portfolio consists of two or more stocks. The return of the portfolio and the standard deviation…

Q: Required: Determine whether each of the following terms is more likely to be associated with…

A: Exploratory Data visualization It's about diving into your data , looking for patterns , trends and…

Q: Respond to the following in a discussion post: Define a balanced scorecard. Discuss at least three…

A: The objective of this question is to define what a balanced scorecard is and to identify at least…

Question

PLEASE ANSWER THEM ALL CORRECTLY FOR AN UPVOTE AND POSITIVE RATINGS. THANK YOU.

WRITTEN WORK # 15
u mco sp he
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
Semi-
Bi-
Monthly
Salary
Name
Annual
Salary
Monthly
weekly
Marites
P11,538
P20,000
Janice
Lyn
P5,000
Leo
P40,000
shoil
Flor
P96,000
Activity 2. Spread my Salary
Direction: Using the spreadsheet, compute for the corresponding contributions of the
followingemployees. Compute also their total deduction. (Show the formula)
E
F
H.
A
INCOME
DEDUCTIONS
Name
Basic Monthly
SSS PHILHEALTH PAGIBIG
TAX
Total
Deductions
Salary
4%
1.50%
2%
12%
4 Magpayo, Lyn
5 Quiambao, Jhaz
6 Cruz, Russel
7 Garcia, Geth
8 Niedao, Maine
9 Mendoza, Rhoda
0 Mallari, Tes
1 Santos, Paula
2 Urbano, Janeen
P20,000.00
P25,000.00
P30,000.00
P40,000.00
P45,000.00
P50,000.00
P55,000.00
P60,000.00
P65,000.00
23

Expert Solution

This question has been solved!

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

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

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

show in excel form
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.
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
Please fill out the missing Colin and show the calaculations and formula
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.
The easiest way to change the order in a chart is in the __________. Multiple Choice underlying spreadsheet slicer chart options chart itself