Financial Analysis Report Assignment

Added on - 16 Sep 2019

  • Dissertation

    type

  • 3

    pages

  • 1088

    words

  • 46

    views

  • 0

    downloads

Showing pages 1 to 1 of 3 pages
FINANCIAL ANALYSIS PROJECT[PART ONE]INTRODUCTIONYou are currently developing a hotel project, Beautiful & Crazy (B&C) Hotel. You plan to open the hotel on January1st, 2017 and your plan is to operate the hotel for 10 years and sell it. First, you would like to know how the hotelwill perform in the next 10 years (from 2017 – 2026). Therefore, you are preparing income statement of the hotelfor 10 years.REQUIREMENTS FOR PROJECT PART ONE1.You must use Microsoft Excel. Handwritten submission will not be accepted.2.All dollar figures should be rounded to the nearest dollar.3.Your submission in ANGEL will be ONE file; an Excel spreadsheet.REQUIRED ANALYSIS1.Prepare the income statement for 10 years (from 2017 to 2026) (Tab 1 in Excel). The format of the incomestatement willNOTfollowthe USALI, but will be a modified version of the summary operation statement.This format will be discussed in the classroom.2.Construct the loan amortization table for 20 years (Tab 2 in Excel).1
desklib-logo
You’re reading a preview
card-image

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Unlock This Document