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

Your company is doing well and has a profit of about $50,000. You want to make your profit work harder so you have looked at some investment opportunities available. They are To insulate the current company offices at a cost of $18,000 which will provide a fuel savings of $1,600 per year over the next 10 years. To pay the lump sum of $30,000 to the mortgage of $40,000 that has a loan term of 10 years at 6.5% interest per annum. To invest $20,000 into a new business, which has been estimated to return the double amount in 6 years’ time. To keep the profit $50,000 in an iSaver account earning a fixed interest of 4.5% per annum for 8 years. After 8 years, there will be no interest for this iSaver account. Assumptions:  - If only a part of the profit $50,000 is invested in a project, the remaining amount is still kept in the pocket (i.e. no investment).  - The investment/cost occurs at the beginning of a year, and the investment benefits are obtained at the end of a year.  - iSaver account calculates the compound interest. (a) Given the profit you have and assuming a discount rate of 4.8%, perform and document appropriate NPV calculations for 10 years for all possible investment options you identified. Graph the results to show the payback analysis of each investment option. You must use Microsoft Excel or an equivalent spreadsheet program to perform and present your calculations.  Do not use the Excel NPV function and demonstrate you understand the formulas by calculating the NPV.  You may confirm the calculated NPV using the Excel NPV function. Ensure you format the spreadsheets so they use references rather than hard coding data.  This allows experimenting with the data, e.g., if I change the discount rate the data should react and change accordingly. Use bolding, colors etc. to ensure the data is easy to interpret. [7 marks] (b) From your calculations in (a), which investment would you take up and why? Use a Weighted Scoring Model (see an example on pages 154-155 of the textbook) to discuss the results and explain in detail why you have chosen one option over the others.  It is not always just the figures that determine the final decision. [3 marks]
 
Create a report in Word or PDF format to present the outcomes of (a) and (b). Use the data, graphs etc. created within the spreadsheet program to present the outcomes.  
Question 2 (10 marks) You are in charge of building a new office for your company. After some discussion with your builder, you identified some of the key tasks, the duration and the costs to complete the building. As you are a project manager you have decided to monitor the building progress using Earned Value Management (EVN). Answer the following questions using the following information
ID Task Name Cost ($) Start Date Duration 1 Lay foundations 18,000 November 1 2 weeks 2 Build frame 34,000 November 4 weeks 3 Install pipes and electrical 10,000 December 6 weeks 4 Make office water-tight 15,000 February 8 weeks 5 Install internal walls and bathroom 20,000 April 12 weeks 6 Install cabinetries 14,000 July 4 weeks 7 Paint office 8,000 August 2 weeks 8 Install light fixtures and appliances 9,000 August 2 weeks  
NOTE: Assume that no task is scheduled to run concurrently, e.g., Task 2 starts after Task 1 completes, Task 3 starts only when Task 2 completes, and so on. Also, assume that each month is made up of exactly four weeks.
(a) What is the planned value of the entire project?
[1 mark] (b) The project manager has managed to keep cost to what was originally budgeted above. At this point, the project has completed Task 4. Up to this point,  i. What is the planned value of the project? ii. What is the actual cost (AC) of the project? Briefly explain how you derive the actual cost. iii. What is the rate of performance (RP) for each task? Using the RPs obtained, calculate the Earned Value (EV), Schedule Variance (SV), Cost Performance Index (CPI), and Schedule Performance Index (SPI) of the project. [1 + 1 + 1 = 3 marks] (c) Unfortunately, two trades resigned after Task 5 was completed and this caused the remaining tasks to exceed its original cost and schedule by 25%, 30%, 40% respectively. At the end of the project, i. What are the CPI and SPI? ii. How is the performance with respect to cost and time? iii. Represent the Planned Value (PV), Earned Value (EV) and Actual Cost (AC) in a chart like the example below.   
Submission Requirements: - Microsoft Excel or equivalent files showing all calculation details, and  - Corresponding reports in Word or PDF format explaining your calculations and conclusions.   
Resources which could be used include  Textbook (very important) Workshop materials on CloudDeakin Lecture notes and useful resources on CloudDeakin Related materials on the Web   
Note particularly that reproducing someone else's work is not permitted. It may be very valuable though to reference and comment on the differences between various works which you find. While you are welcome to collaborate with your fellow classmates, you cannot forward your work onto somebody else, allow somebody else to copy from your own work, and most important any work submitted must be entirely your own.
Your attention is drawn to the Plagiarism Statement on CloudDeakin. Anyone using cut-and-paste or copying other people’s work will be easily detected; the outcome is a disciplinary committee hearing and an automatic zero for the assignment. No excuses.
There is no page number limitation for this assignment. But irrelevant materials should not be included. Please note an assignment longer in length DOES NOT mean a higher mark you will get. Remember: if the assignment marker can’t find the answer, then you will not get the mark for it. Make it easy to understand.
Appropriate referencing should be done. However, do not provide a reference for every separate fact.  
The assignment must be submitted to CloudDeakin before or on the due date. Late submission will lead to a mark penalty or not being assessed (for more details, please read the Unit Guide on CloudDeakin carefully).
If you wish to apply for an extension, application should be submitted to the unit chair before the due date. Documentary evidence of the disadvantage causing this request, and an ongoing assignment representing the work you have completed are expected to be submitted. A judgement will be made by the unit chair as to whether an extension shall be granted



testimonials icon
Mean girls and looking for alibrandi Today I will be doing a speech on looking for alibrandi and mean girls I will be...
testimonials icon
Treatment Plan And Facilitation Skills Report Review the Cassandra Case Study along with your completed Risk and Needs Assessment Report as...
testimonials icon
Analyze nonverbal interpersonal communication in your workplace by choosing a routine interaction you have with a coworker or a boss. In a...
testimonials icon
1) Discuss the benefits of using comparative analysis of governments. 2) Explain why political systems cannot be compared strictly on thei...
testimonials icon
In the banking industry, the return on equity ratio or percentage is used to evaluate the financial performance of a bank. Such information is extr...
testimonials icon
MANAGERIAL STATISTICS FOR BUSINESS finalsee file attached please,,,,,,,,,,,,,,,,,,,,...
testimonials icon
Child abuse and maltreatment is not limited to a particular age and can occur in the infant, toddler, preschool, and school-age years. Choose one o...
testimonials icon
 This is about outbreak that happens in restaurant. this event have two questions need to be answered. I would like to answer these two questi...

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