Ask a question to Desklib · AI bot


Financial Analysis Report Assignment

Added on -2019-09-16

| 3 pages
| 1088 words

Trusted by 2+ million users,
1000+ happy students everyday

FINANCIAL ANALYSIS PROJECT[PART ONE]INTRODUCTIONYou are currently developing a hotel project, Beautiful & Crazy (B&C) Hotel. You plan to open the hotel on January 1st, 2017 and your plan is to operate the hotel for 10 years and sell it. First, you would like to know how the hotel will perform in the next 10 years (from 2017 – 2026). Therefore, you are preparing income statement of the hotel for 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 income statement will NOT follow the 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

Found this document preview useful?

You are reading a preview
Upload your documents to download
Become a Desklib member to get accesss

Students who viewed this