文档下载 文档下载导航
设为首页 | 加入收藏
搜索 请输入内容:  
 导航当前位置: 文档下载 > 所有分类 > IT/计算机 > 电脑基础知识 > INFO1003_Foundamental of IT_2012 Semester 2_tutorial week 4_Week 4 - Sensivity Analysis
侵权投诉

INFO1003_Foundamental of IT_2012 Semester 2_tutorial week 4_Week 4 - Sensivity Analysis

University of Sydney_INFO1003_Foundamental of IT_2012 Semester 2

1. a. Starting from page 50 of the reference book, follow the steps to create different

scenarios (60% highest, 70% highest, 80% highest and 90% highest scenarios)

b. Continue with this example, this time using the goal seek functionality to achieve

$4000

a. Establish the spreadsheet example from page 55 of the reference book here, and

follow the example to achieve comparisons for the various interest rate

b. Establish the spreasheet example from page 57 of the reference book here, and follow

the example to achieve comparisons for the various interest rate as well as various

months

As always, Jack Sparrow is trying to seek out immortality. However, this time, he is very, very short on cash, preventing him from being able to bargain with passing merchants as well as pay for general survival needs for himself and his crew. He turns to the closest loan shark with a grudge on Captain Barbossa to borrow $250,000. Jack requires your expertise to find the exact loan combination which will give him the most profit.

(a) Use the PMT function to calculate what would be Jack’s payment per month with

the differing interest rates. THEN compare this with Excel’s Scenario for each loan

INFO1003_Foundamental of IT_2012 Semester 2_tutorial week 4_Week 4 - Sensivity Analysis

option. Note: you need to change the amount borrowed to $250,000

第1页

你可能喜欢

热门文档

相关文档

站点地图 | 文档上传 | 侵权投诉 | 手机版
本站所有资源均来自互联网,本站只负责收集和整理,均不承担任何法律责任,如有侵权等其它行为请联系我们.
文档下载 Copyright 2013 doc.guandang.net All Rights Reserved.  -  email