BUS 211 Excel Functions Mid Term Exam Worksheet this is an exam please help as quick as possible it contains five different sheets but its not too long it

BUS 211 Excel Functions Mid Term Exam Worksheet this is an exam please help as quick as possible it contains five different sheets but its not too long it might take an hour or less to be done BUS 211 Midterm II Exam
Instructions:
1. Place your Name in G16
2. You can work the sheets in any order.
3. Use the instructions on the associated Word file for details on each sheet. You may print out the instruct
if you desire.
Save Appropriately and Save Frequently!
Be Sure to Save to your Z: drive and then upload to Desire2Learn before the exam period closes.
Contents:
Intro
IfAndOR and Lookup
Error Correct FIN WhatIF
Macro
WhatsMyGrade
Product Mix
3/22/2015
ACE
Created By:
Date Created:
This Introductory Sheet with generic instructions.
Problem Exercise involving If, And, or Or function(s) and lookup functions.
Problem Exercises involving Error Correction, Financial Function(s) and WhatIF a
Problem Exercise involving creating a Macro and associated activities.
Problem Exercise involving creating a Macro and associated activities.
Problem Exercise to find a solution to a problem using Solver
Modified By:
Date Modified:
Exam
eet. You may print out the instructions
he exam period closes.
ons.
tion(s) and lookup functions.
Financial Function(s) and WhatIF analysis
and associated activities.
and associated activities.
em using Solver
6/18/2020
Joe’s Fish Shop
Weekly Payroll Information
Today’s Date
6/18/2020
Employee
Hours
Holloway
Igu
Jaggart
Jones
Jankowski
Karls
Lee, J.
Lee, H.
Mankowski
Miller
Nywatt
Orton
Pi
Ramirez
Sanchez
Shapiro
Thomson
Wu, A.
Wu, T.
44
39
45
42
37
40
44
42
39
39
43
39
43
40
41
40
38
40
40
Base
Hourly
Pay
Total:
Gross
Wage
Health
Insurance
Total
Health Plan Weekly Costs
Premier
Standard
Basic
$163
$138
$119
Employee Information
Employee
Jankowski
Nywatt
Sanchez
Orton
Shapiro
Wu, T.
Jaggart
Mankowski
Karls
Ramirez
Thomson
Lee, J.
Lee, H.
Igu
Pi
Wu, A.
Jones
Miller
Holloway
Wage
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
15.38
15.80
15.91
16.18
17.86
13.91
14.11
15.39
16.47
17.54
19.65
13.05
13.08
13.14
16.00
17.37
17.54
18.87
19.65
Health
Plan
Basic
Basic
Basic
Basic
Basic
Premier
Premier
Premier
Premier
Premier
Premier
Standard
Standard
Standard
Standard
Standard
Standard
Standard
Standard
Demo: Workbook Auditing & Return on Investm
Assumptions
Proposed Capital Equipment Cost
Equipment Lifetime (Years)
Salvage Value
Effective Tax Rate
Incremental Price
Initial Units Sold
$
$
$
Required Return on Capital Investment
Sales Growth Rate
Value
4,000,000
6
760,000
35%
2.00
3000000
15.0%
2.0%
Name
EqCost
Life
Salvage
Tax
Price
InitUnits
IRate
GRate
Capital Expenditure Decision Support Worksh
Year
Capital Expenditure Assumptions:
Capital Expenditure
Units Sold
0 (This Year)
$
4,000,000
0 (This Year)
Materials
Labor
Depreciation
10,000
Total Incremental Expenses
$
Operating Income Before Taxes
Taxes
$
Operating Income After Taxes
$
Operating Income After Taxes + Depreciation
Net Working Capital
Change in Net Working Capital
Salvage Value
Taxes on Salvage Value
Free Cash Flow
10,000 $
3,060,000
1
#NAME?
Incremental Income from Project
Incremental Expenses for Project
NPV: Net Present Value
IRR: Internal Rate of Return
2
3,000,000
Capital Budgeting Calculations (Make):
Cumulative Free Cash Flow:
1
2
$
6,120,000
750,000
600,000
968,000
2,318,000 $
750,000
600,000
733,744
2,083,744
(10,000)
(3,500)
(6,500)
#NAME?
#NAME?
#NAME?
$
4,036,256
1,412,690
2,623,566
$
(6,500)
150,000
150,000
#NAME?
$
150,000
–
3,357,310
150,000
–
$
$
(4,156,500)
(4,156,500)
#NAME?
#NAME?
$
$
3,357,310
#NAME?
urn on Investments
upport Worksheet
Year
3
3,121,200
3
4
3,183,624
4
5
3,247,296
5
6
3,312,242
6
$
6,242,400 $
6,367,248 $
6,494,593
$
750,000
600,000
556,178
1,906,178 $
500,000
600,000
421,583
1,521,583 $
250,000
600,000
319,560
1,169,560 $
4,336,222 $
1,517,678
2,818,544 $
4,845,665 $
1,695,983
3,149,682 $
5,325,033
1,863,762
3,461,272
#VALUE!
#VALUE!
#VALUE!
3,374,722 $
100,000
(50,000)
3,571,265 $
50,000
(50,000)
3,780,831
25,000
(25,000)
#VALUE!
$
$
$
$
3,424,722 $ 3,621,265 $ 3,805,831
#NAME?
#NAME?
#NAME?
#VALUE!
125,000
600,000
242,226
967,226
(25,000)
760,000
(452)
#VALUE!
#VALUE!
Total Depreciation
$ 3,241,291
Book Value
$ 758,709
Joe’s Fish Shop
Payroll Date: 11/11/2009
Payroll Processor:
Excel Midterm2
IF Letter Grade
Possible:
Your Scores:
IfAnd
Q1
25
Grade
A
AB+
B
BC+
C
CD
F
Error
Q2
30
Macros
Q3
30
MyGrade Summary
Q4
Q5
12
3
% of Course Points
95
Purchase answer to see full
attachment