Developing master budget and pro-forma financial statement

Assignment Help Financial Accounting
Reference no: EM13777666

The Gold Bay Hotel is in the process of developing a master budget and pro-forma financial statements for 1999.  The beginning balance sheet for the fiscal year 1999 is estimated to be:

Gold Bay Hotel

Estimated Balance Sheet 1/1/9

Cash                                $    20,000            Accounts Payable             $     20,00

Accounts Receivable            30,000            Notes Payable                        500,000

Facilities                           3,010,000            Capital Stock                         100,000

Accumulated Dep.          (1,100,000)           Retained Earnings               1,340,000

Total Assets                   $1,960,000            Total Equities                    $1,960,000

During the year the hotel expects to rent 30,000 rooms.  Rooms rent for an average of $90 per night.  The hotel expects to sell 40,000 meals during the year at an average price of $20 per meal.  The variable cost per room rented is $30 and the variable cost per meal is $8. The fixed costs not including depreciation is expected to be $2,000,000.  Depreciation is expected to be $500,000.  The hotel also expects to refurbish the kitchen at a cost of $200,000, which is capitalized (included in the facility account).  Interest of the note payable is expected to be $50,000 and $100,000 of the note payable will be retired during the year.  The ending accounts receivable amount is expected to be $40,000 and the ending accounts payable is expected to be $30,000.

Prepare pro-forma financial statements (Income Statement, Cash Flow, and Balance Sheet) for the end of the year.

Reference no: EM13777666

Questions Cloud

Promoting healthy prenatal development : During a healthy pregnancy, the womb provides a protective environment for the fertilized egg (or zygote) to develop into an embryo, and then into a fetus.
Probability and non-probability sampling techniques : A researcher attends an art reception in a major metropolitan city. She decides to approach people over the age of 50 and ask them to fill out a brief survey about purchasing artwork. Is this a probability or a non-probability sampling technique? ..
How should erin conduct herself in her future visits : How should Erin conduct herself in her future visits to the Dijon operation in order to get down to business? Should the company replace Erin with another person for the position of international liaison? Explain your answer
Nest present value of this machine to nearest whole dollar : The Whitton Company uses a discount rate of 16%. The company has an opportunity to buy a machine now for $18,000 that will yield cash inflows of $10,000 per year for each of the next three years. The machine would have no salvage value. The nest pres..
Developing master budget and pro-forma financial statement : The Gold Bay Hotel is in the process of developing a master budget and pro-forma financial statements for 1999.  The beginning balance sheet for the fiscal year 1999 is estimated to be: During the year the hotel expects to rent 30,000 rooms.  Rooms r..
Contrast the vocational rehabilitation process : Compare and contrast the vocational rehabilitation process between public, private for public, and community based nonprofit vocational rehabilitation practice. Please provide an example for your response
How do factors like high self-efficacy expectations help us : How do factors like high self-efficacy expectations, control, and humor help us adjust to stress?
Considering an investment proposal : Parks Company is considering an investment proposal in which a working captial investment of $10,000 would be required. The investment would provide cash inflows of $2,000 per year for six years. The working capital would be released for use elsewher..
Environmental issues that relate to the clean water act : An environmental group, SafePack Materials Pollute, has sprung up and launched an Internet campaign geared toward compelling fruit producers to stop purchasing your packing materials. The situation at hand raises environmental issues that relate t..

Reviews

Write a Review

Financial Accounting Questions & Answers

  How does unearned revenue link cash with sales revenue

Where does the account Unearned Revenue appear in the financial statements? How does Unearned Revenue link Cash with Sales Revenue?

  On december 31 20xx lbiincorporateds records indicate the

on december 31 20xx lbiincorporateds records indicate the following sales results for the yearcash sales 1025000credit

  Qa the z company sold goods to the x company fob

qa. the z company sold goods to the x company fob destination on 31st december 2011. the z company added the sale in

  Predetermined overhead rates to apply manufacturing overhead

The Raleigh Company is located in North Carolina and uses predetermined overhead rates to apply manufacturing overhead costs to jobs. The predetermined overhead rate is based on machine hours in Department A and direct labor costs in Department B. At..

  Compute the companys predetermined overhead rate

Harris Fabrics computes its predetermined overhead rate annually on the basis of direct labor-hours. At the beginning of the year, it estimated that 29,000 direct labor-hours would be required for the period’s estimated level of production.

  Evaluate the total overhead applied to production during may

Evaluate the total overhead applied to production during May. Determine the cost of the ending work in process inventory. Evaluate the cost of jobs completed during May. Calculate the cost of goods sold for the year ended May 31.

  Calculation of total projected sales for the quarteranswer

calculation of total projected sales for the quarter.answer the question based on the following

  Nbspfrom the data prepare journal ledger trial balance

nbspfrom the data prepare journal ledger trial balance financial statements.for the past several years dawn lytle has

  What are the general journal entries

On March 10, 2002, the supplies fund notified the city that it owned $1,500 for supplies used that cost $1,200. The supplies fund also notified the city's water utility fund that it owed $3,400 for supplies used that cost $2,700. What are the general..

  Securities and exchange commission

The Sarbanes-Oxley Act of 2002 requires that all U.S. corporations under the jurisdiction of the Securities and Exchange Commission

  Need of cash to be maintained

Calculation of requirement of cash to be maintained and The Wallace Company must maintain a minimum cash balance of $30,000. At the beginning of February the company's cash balance was $50,000.

  Determine the inventory balance at december

Determine the inventory balance at December 31, 2004 and evaluate the inventory balance at Decmber 31, 2004, without the reduction for LIFO reserve?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd