Financial Analysis Report Assignment

Added on - 16 Sep 2019

Trusted by 2+ million users,
1000+ happy students everyday
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 are reading a preview
Upload your documents to download or

Become a Desklib member to get access