BIS 221 UOPX Financial Functions Worksheet

User Generated

Gungthl308

Business Finance

BIS 221

University of Phoenix

BIS

Description

Unformatted Attachment Preview

asdf Education Apple PC Sales Utah Population This assignment file relies on a set of macros to handle submission and scoring. Before you may begin the assignment, you must enable macros in this workbook. Depending the version of Excel and the security settings, you may see a prompt similar to those below. If you have already dismissed the prompt, you may need to close this workbook and open it again. Enable Macros to Begin Assignment You are responsible for tracking daily sales. The table below lists a number of transactions for your company. Notice that the sales tax amount and transaction totals are not filled in. Complete the tasks to complete the table. Sales Tax Rate 6,75% Transaction ID Amount 578 $42,00 579 $167,00 580 $209,00 581 $142,00 582 $234,00 583 $88,00 584 $197,00 585 $209,00 586 $163,00 587 $151,00 588 $103,00 589 $148,00 590 $51,00 Grand Total Sales Tax Total There are 30 Major League Baselball (MLB) teams. The table below lists the 2010 and 1990 payroll and win totals f fans complain because the league does little to regulate the amount of money teams can pay for salaries. They arg put teams from small markets (that earn less revenue) at a disadvantage. Complete the tasks by inserting your for disadvantage? Major League Baseball Salaries by Team DIVISION TEAM 2010 PAYROLL 1990 PAYROLL 2010 WINS 1990 Wins AL East Baltimore Orioles $81.612.500 $10.037.084 66 76 AL East Boston Red Sox $162.447.333 $20.983.333 89 88 AL East New York Yankees $206.333.389 $20.991.318 95 67 AL East Tampa Bay Rays $71.923.471 NA 96 NA AL East Toronto Blue Jays $62.234.000 $18.486.834 85 86 AL Central Chicago White Sox $105.530.000 $9.496.238 88 94 AL Central Cleveland Indians $61.203.966 $15.152.000 69 77 AL Central Detroit Tigers $122.864.928 $18.092.238 81 79 AL Central Kansas City Royals $71.405.210 $23.873.745 67 75 AL Central Minnesota Twins $97.559.166 $15.106.000 94 74 AL West Los Angeles Angels $104.963.866 $21.870.000 80 80 AL West Oakland Athletics $51.654.900 $19.987.501 81 103 AL West Seattle Mariners $86.510.000 $12.841.667 61 77 AL West Texas Rangers $55.250.544 $15.104.372 90 83 NL East Atlanta Braves $84.423.666 $13.328.334 91 65 NL East Florida Marlins $57.029.719 NA 80 NA NL East New York Mets $134.422.942 $22.418.834 79 91 NL East Philadelphia Phillies $141.928.379 $13.953.667 97 77 NL East Washington Nationals* $61.400.000 $16.656.388 69 85 NL Central Chicago Cubs $146.609.000 $14.496.000 75 77 NL Central Cincinnati Reds $71.761.542 $14.769.500 91 91 NL Central Houston Astros $92.355.500 $18.830.000 76 75 NL Central Milwaukee Brewers $81.108.278 $20.019.167 77 74 NL Central Pittsburgh Pirates $34.943.000 $15.656.000 57 95 NL Central St. Louis Cardinals $93.540.751 $20.923.334 86 70 NL West Arizona Diamondbacks $60.718.166 NA 65 NA NL West Colorado Rockies $84.227.000 NA 83 NA NL West Los Angeles Dodgers $95.358.016 $21.618.704 80 86 NL West San Diego Padres $37.799.300 $18.588.334 90 75 NL West San Francisco Giants $98.641.333 $20.942.333 92 85 * The Washington Nationals were the Montreal Expos in 1990 NA = The team did not exist in 1990 990 payroll and win totals for each team (notice that four teams were added after the 1990 season). Some MLB n pay for salaries. They argue that the teams that spend the most money will win the most games. This would tasks by inserting your formulas (or responses) in column I for each task. Are small market teams at a Response Statistical Functions Task Number of MLB Teams in 1990 Number of MLB teams in 2010 Total salaries paid in 1990. Total salaries paid in 2010. Average salary paid by the teams in 1990. Average salary paid by the teams in 2010. Maximum team salary amount in 1990. Minimum team salary amount in 2010. Financial Functions Complete each task by inserting the appropriate function, referencing the appropriate cells in the task da Task 1 Data Loan Amount Interest Rate* Number of Payments -$175.000,00 4,25% 360 Monthly Payment * Remember to divide the interest rate by 12 (to calculate the monthly interest rate) in your function. Task 3 and 4 Data Loan Amount Monthly Payment Number of Payments -$212.000,00 $950,00 360 Nominal Interest Rate Effective Interest Rate * Remember to multiply the nominal interest rate by 12 (to calculate the annual interest rate). Task 6-8 Data Loan Amount Interest Rate* Number of Payments 15 Year Mortgage -$310.000,00 4,50% 180 30 Year Mortgage -$310.000,00 4,50% 360 $0,00 $0,00 Monthly Payment Total Payments (PMT * # of PMTs) Difference between 30-year and 15-year payback (the 30 year amount - the 15 year amount) * Remember to divide the interest rate by 12 (to calculate the monthly interest rate) in your functions. Functions ncing the appropriate cells in the task data, in the specified cells. Task 2 Data Monthly Payment Interest Rate* Number of Payments -$1.200,00 4,25% 360 Loan Amount * Remember to divide the interest rate by 12 (to calculate the monthly interest rate) in your function. Task 5 Data Monthly Savings Amount Interest Rate* Number of Months -$75,00 2,75% 36 Future Account Balance * Remember to divide the interest rate by 12 (to calculate the monthly interest rate) in your function. asdf World Records World Records Copied World Records Sorted Enable Macros to Begin Assignment This assignment file relies on a set of macros to handle submission and scoring. Before you may begin the assignment, you must enable macros in this workbook. Depending the version of Excel and the security settings, you may see a prompt similar to those below. If you have already dismissed the prompt, you may need to close this workbook and open it again.
Purchase answer to see full attachment
Explanation & Answer:
1 Worksheet
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

You are responsible for tracking daily sales. The table below
lists a number of transactions for your company. Notice that
the sales tax amount and transaction totals are not filled in.
Complete the tasks to complete the table.
Sales Tax Rate

6.75%

Transaction ID Amount
578
$42.00
579
$167.00
580
$209.00
581
$142.00
582
$234.00
583
$88.00
584
$197.00
585
$209.00
586
$163.00
587
$151.00
588
$103.00
589
$148.00
590
$51.00
Grand Total

Sales Tax
$2.84
$11.27
$14.11
$9.59
$15.80
$5.94
$13.30
$14.11
$11.00
$10.19
$6.95
$9.99
$3.44

Total
$44.84
$178.27
$223.11
$151.59
$249.80
$93.94
$210.30
$223.11
$174.00
$161.19
$109.95
$157.99
$54.44
$2,032.52

There are 30 Major League Baselball (MLB) teams. The table below lists the 2010 and 1990 payroll and win totals f
fans complain because the league does little to regulate the amount of money teams can pay for salaries. They arg
put teams from small markets (that earn less revenue) at a disadvantage. Complete the tasks by inserting your for
disadvantage?

Major League ...


Anonymous
Very useful material for studying!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags