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

option. Note: you need to change the amount borrowed to $250,000
INFO1003_Foundamental of IT_2012 Semester 2_tutorial week 4_Week 4 - Optimisation_电脑基础知识_IT/计算机_专业资料。University of Sydney_INFO1003_Foundament...
INFO1003_Foundamental of IT_2012 Semester 2_tutorial week 4 Solution_copyCentre(1)_电脑基础知识_IT/计算机_专业资料。University of Sydney_INFO1003_Foundamen...
INFO1003_Foundamental of IT_2012 Semester 2_tutorial week 4 Solution_manufacturing_ans(1)_电脑基础知识_IT/计算机_专业资料。University of Sydney_INFO1003_F...
INFO1003_Foundamental of IT_2012 Semester 2_tutorial week 4 Solution_ebayStrategy_ans(1)_电脑基础知识_IT/计算机_专业资料。University of Sydney_INFO1003_F...
INFO1003_Foundamental of IT_2012 Semester 2_tutorial week 10_Week 10 - Databases Questions_电脑基础知识_IT/计算机_专业资料。University of Sydney_INFO1003_...
INFO1003_Foundamental of IT_2012 Semester 2_tutorial week 6_Week 6 - Control Questions_电脑基础知识_IT/计算机_专业资料。University of Sydney_INFO1003_Fou...
INFO1003_Foundamental of IT_2012 Semester 2_tutorial week 10_Week 10 - Data Modelling Questions_电脑基础知识_IT/计算机_专业资料。University of Sydney_INFO...
INFO1003_Foundamental of IT_2012 Semester 2_tutorial week 3_Week 3 - Forecasting Questions_电脑基础知识_IT/计算机_专业资料。University of Sydney_INFO1003_...
INFO1003_Foundamental of IT_2012 Semester 2_tutorial week 3 Solution_Week 3 - Forecasting Answers_电脑基础知识_IT/计算机_专业资料。University of Sydney_INF...
INFO1003_Foundamental of IT_2012 Semester 2_tutorial week 3 Solution_telstra_ans(1)_电脑基础知识_IT/计算机_专业资料。University of Sydney_INFO1003_Foundam...
热门文档