Major Assignment Instructions (3).docx

Major Assignment Instructions (3).docx - AFIN613 Financial...

Info icon This preview shows pages 1–2. Sign up to view the full content.

AFIN613 Financial Statement Analysis & Modelling Major Assignment Assessed Activity Session 1 2017 Overall Purpose and Description: Create an integrated financial projection model in Excel for determining the rents to be charged for the lease of an aircraft to an airline from an Aircraft Leasing Company. The aircraft will be owned and leased from a Special Purpose Company which is a subsidiary of the Aircraft Leasing Company. As part of the assignment you are to present the financial Statements of the Special Purpose Company. . Assignment submission: You should submit your assignment in iLearn at . There are instructions on how to submit your assignment in the Major Assignment section of the Financial Statement Analysis & Modelling iLearn site. What to submit: The Assignment is in two parts thus requiring two submissions on two different dates. Extra information will be released after submission of Part 1 that you will need in order to do Part 2. Part 1 submission: You must submit an Excel file which calculates the rent you can charge for a specific set of assumptions. Part 2 submission: You must submit an Excel file with the Financial Statements for the Special Purpose Company containing I/S, B/S and Cash Flow Statement (CFS). For the second part you will also include a discussion which can be par of the Excel document or a separate word document. In the Inputs sheet (or similar) in both documents please include your name and student ID. Submission date: Part 1 and Part 2 – Please see iLearn for details Penalty for late submission: If you have extenuating circumstances that prevent you from submitting your assignment by the due date, please make arrangements with your lecturer prior to the due date. Unless prior arrangements have been made, any late submission of case studies will automatically be penalised. In the absence of special circumstances, a zero mark will apply. Nature: This is an individual assignment. General discussion of the topic is allowed but the final conclusions and written submission must be your own work.
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Image of page 2
This is the end of the preview. Sign up to access the rest of the document.
  • One '14

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern