Even complicated and confusing topics will be easily developed and covered if you request our help writing an essay. Place an order today!

Teaching Week 9 Timetabling Week 15 Seminar 6 Financial Models LearningObjectivesoftheSeminarAchievedthrough1.DemonstrategoodunderstandingofCompletionoftask1 future and present values under 2 interestrate regimes i.e. simple and compound,respectively;2. Demonstrate good skills on creating adynamic working sheet in Excel;Completion of the two seminar tasks3. Demonstrate good understanding of NPVand IRR;Completion of task 24. Know the use of Excel function NPV andIRRCompletion of task 25. Show independent learning skills The application of Excel function NPV &IRR6. Communication and problem solvingskillsPeer discussion and ask questions to tutorTask 1The following are two investment scenarios:Scenario 1: £8,000 at 6.5% with simple interest rateScenario 2: £5,000 at 6.5% with annual compound interest rateIn Excel, draw up a table with the following data: Scenario number, Capital,Interest rate, Type of Interest. Then, please create a dynamic process in the tableto calculate the accrued interest each year for 45 years from now on, for each ofthe scenario.Graph the sums accrued and identify what year the sums accrued swap from oneinvestment being the largest to the other.Task 2A business has two projects to invest in, as follows:Create a new spread sheet, calculate NPV for the following projects at discountrates of 3% and 7%, respectively, by creating a dynamic process.Project 1 Project 2Year Cashinflows Cashoutflows Cashinflows Cashoutflows0 0.00 70,000.00 0.00 70,000.001 24,000.00 13,000.00 25,000.00 15,000.002 22,000.00 1,000.00 25,000.00 –3 25,000.00 – 20,000.00 –4 25,000.00 – 43,000.00 21,000.005 17,500.00 7,500.00 20,000.00 5,000.00P1: NPV P2: NPVThen,a) by using a built-in/Excel function, calculate the NPV for each projectwith discount rates of 3% and 7%, respectively;b) By comparing the NPVs at the rate of 3%, which project gives the betterreturn to the company;c) Construct a table to show the NPV for the above selected project i.e. theproject gives the better return) for a range of discount rates between 3%and 16%;d) Construct a graph to estimate the IRR using your table;e) Confirm the estimate made in step d) using the built-in/Excel IRRfunction.

  • Assignment status: Already Solved By Our Experts
  • (USA, AUS, UK & CA PhD. Writers)
QUALITY: 100% ORIGINAL PAPER –  NO PLAGIARISM – CUSTOM PAPER

testimonials icon
Running Head: CONFLICT STYLE ASSESSMENTConflict Style AssessmentStudent NameInstitution AffiliationCONFLICT STYLE ASSESSMENT2What were the findings o...
testimonials icon
/*! elementor - v3.6.5 - 27-04-2022 */ .elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading...
testimonials icon
                   ...
testimonials icon
Name:Student ID:Course:University:Date:Failure of Expatriate AssignmentsThere are some major factors contributory to failure rates, these can include...
testimonials icon
Assignment: Individual Reflection: Blue Print for Professional and Personal Growth Part One: Executive Summary of MBA ProgramAs y...
testimonials icon
Reading summaries 5,6 and 7 5-After reading all of Chapter 5, please select ONE...
testimonials icon
You are running for an elected position as a state representative for your district. Part of your potential constituent’s concerns includes the n...
testimonials icon
egin by reading the "Mattel Confronts Its Marketing Challenges" Case in the text. Prepare a case analysis and proposal with a compre...
testimonials icon
   Need answers only I am not increasing what I pay....on a budget...lol...
testimonials icon
You have been asked to write a report for a group of new stock brokers about the NYSE-Euronext and the NASDAQ. Visit both the NYSE Homep...

Other samples, services and questions:

Calculate Price

When you use PaperHelp, you save one valuable — TIME

You can spend it for more important things than paper writing.

Approx. price
$65
Order a paper. Study better. Sleep tight. Calculate Price!
Created with Sketch.
Calculate Price
Approx. price
$65