MIS462Summative02

MIS 462 Summative Assignment

Email Address:

First Name:

Last Name:

Semester:

Class:

StarID:

Section:

Assignment:

500 points

Problems, Chapters 13 to 18

Do all of these problems in a single Excel Workbook.
Solve each problem on a separate Worksheet.
Your Excel File must be setup like you did in Formative01 with appropriate-Worksheet tab names:

(200) When done, upload your file, named Summative02.xlsx, to the D2L Assignment Folder 'Summative02'.

Paste Special-Chapter 13, Problem 3

The file ProductPaste.xlsx contains data on quarterly sales for four products.
Copy this data to another range on the same page so that quarterly sales are read across instead of down.
Link your copied data to the original data so that your computation of annual sales in the copied data range will reflect changes entered in rows 5-8.

(25) 1. Paste a copy of the transposed data range below:

Auditing-Chapter 15, Problem 1

In the car NPV example using NPVAudit.xlsx, enter below the cell references for the following:

(25) 2. The direct dependents of the tax rate.

cell references:

(25) 3. All dependents of the tax rate.
cell references:

(25) 4. The direct dependents and all dependents of the Interest Rate.
cell references:

(25) 5. The direct precedents and all precedents for year 4 unit sales.
cell references:

(25) 6. The direct precedents and all precedents for year 3 costs.
cell references:

Sensitivity Analysis-Chapter 16, Problem 4

7. (50) For our mortgage example using mortgagedt.xlsx, suppose you know the annual interest rate will be 5.5 percent.
Create a table that shows for amounts borrowed between $300,000 and $600,000 (in $50,000 increments) the monthly payments for a 15-year, 20-year, and 30-year mortgage.
Below enter the montly payment from the table for a $400,000 loan, 20 year mortgage.

monthly payment:

Goal Seek-Chapter 17, Problem 2

(50) 8. For the car Net Present Value example (NPVaudit.xlsx) in Chapter 15, by what rate do annual sales need to grow for total NPV to equal $1,000,000?

Growth Rate:

Scenario Manager-Chapter 18, Problem 3

For the lemonade stand example, lemonade.xlsx, in Chapter 16, use the Scenario Manager to display a report summarizing profit for the following scenarios:

Scenario

Price

Unit cost

Fixed cost

High cost and high price

$5

$1

$65,000

Medium cost and medium price

$4

$0.75

$45,000

Low cost and low price

$2.50

$0.40

$25,000

(50) 9. Examine the results. What is the value of profit for the 'Low cost and low price' scenario?

value:

*Scenario*	*Price*	*Unit cost*	*Fixed cost*
High cost and high price	$5	$1	$65,000
Medium cost and medium price	$4	$0.75	$45,000
Low cost and low price	$2.50	$0.40	$25,000