HB 358 Individual assignment #2
.docx
keyboard_arrow_up
School
Michigan State University *
*We aren’t endorsed by this school
Course
358
Subject
Finance
Date
Apr 3, 2024
Type
docx
Pages
4
Uploaded by ChancellorGrasshopperPerson997
1 HB 358 Individual Assignment #2 Thursday - NAME: Spartan Hotel Information You have been assigned to prepare and analyze pro forma financial statements for the Spartan Hotel. The Spartan Hotel is a full service 320 room property which is in the process of being purchased by a group of private investors. The property has been fully renovated with the exception of the hotel's restaurant which is in the process of construction and will be open in January 2025 at a cost of $880,000. The hotel has historically had an ‘average room rate of $310 per night with an average occupancy rate of 86% annually. The total food and beverage revenues for 2024 are expected 10 be unchanged at $980,000 for the year. The hotel's food and beverage department has traditionally had an 80% to 20% mix of food to beverage revenues. Other income generated mostly from in-room services and is equal to 2.5% of the hotel’s total rooms revenue. Cost of sales percentage will remain constant for the 4 years. After meeting with the investors, management and the controller of the hotel you have been given the following information and forecasted figures in order to prepare the 2024-2027 pro forma income statement and the 2024-2027 pro forma balance sheet. Assume all expense percentages remain constant except where increases are noted. Ingnore the fact that 2024 is a leap year. 2025 Rooms revenues will increase by 3.75% over 2024 Food and Beverage revenues will increase by $4500 per day over 2024 Other income will increase by 1.5% over 2024 Salaries, wages and benefits expenses willincrease by 0.7% over 2024 Ulilties expenses willincrease by 0.5% over 2024 2026 Rooms revenues will increase by 6% over 2025 Food and Beverage revenues will increase by 14% over 2025 Other income will increase by 1.0% over 2025 Salaries, wages and benefits expenses willincrease by 1.0% over 2025 Direct operating expenses will increase by 0.4% over 2025 Uliities expenses willincrease by 0.5% over 2025 2027 Rooms revenues will increase by 6% over 2026 Food and Beverage revenues will increase by 12% over 2026 Other income will decrease by 1.5% over 2026 Salaries, wages and benefits expenses will increase by 0.5% over 2026 Direct operating expenses vill increase by 0.4% over 2026 General & Administrative expenses willincrease by 0.3% over 2026 Ulilties expenses willincrease by 0.6% over 2026 Occupancy costs willincrease by 0.7% over 2026 NOTE: For all years assume the that food to beverage revenues mix remains 80% to 20% Round all figures after calculating to the nearest dollar (no cents) and percentages to the nearest 0.1% (ie. 23.441 = 23.4) Balance Sheet Information Use the Balance Sheet information to calculate the pro forma ratios Calculate the following ratios for the Spartan Hotel's financial analysis (2024 - 2027) Return on Assets Return on Equity Deb ratio Deb to Equity ratio Curent ratio Profit margin HB 358 Individual Assignment #2 Due Thursday 3/21/2043 NAME: [Spartan Hotel 2024 I 2025 I 2026 2027 | Pro Forma Income Statement Dolars | % | Dolars | % | Dolars | % Dolars | % | Revenues Rooms Food Beverage Other Total Reven: Cost of sales 29.0%) 29.0%) 29.0%)| 29.0%) Gross Profit Expenses Salaries, Wages and Benefits 33.0%)] Direct Operating Expenses 6.0%| Marketing 4.0%| Repair and Maintenance 6.0%| General and Administrative expenses 5.0%) Utilities 5.0%) Total Operating Expenses Occupancy Expense 5.0%] Property taxes 3.0%] Insurance 1.0%] Depreciation 5.0%] Interest 3.0%] Total Non-operating Expenses Total Expenses [ [ I I [ I Total Income (Loss) before Taxe [ I [ | [ [
NAME: |Spartan Hotel 31-Dec24 | 31-Dec-25 | 31-Dec-26 | 31-Dec-27 | [Balance Sheet Dollars__| Dollars__| Dollars__| Dollars__| |AsSETS [Current Assets 4,662,925 4,662,725 4,570,535| 5,720,525| |Fixed Assets 13,988,165 14,768,165 14,630,065 14,435,125 [ToTAL ASSETS 18,651,090 19,430,890 19,200,600 20,155,650| |LIABILITIES & OWNER'S EQUITY i |Current Liabilities 1,119,255 1,164,055| 1,246,035| 1,303,340| |Long-Term Liabilities 6,527,810| 7,297,810| 7,202,810] 7,127,810] [investors' Equity 11,004,025 10,969,025 10,751,755 11,724,500| [TOTAL LIABILITIES & OWNER'S EQUITY 18,651,090| 19,430,890 19,200,600] 20,155,650] NAME: Spartan Hotel 2024 2025 2026 2027 Ratio Analysis (2024-2027) Return on Assets Return on Equity Debit ratio Debt to Equity ratio Current ratio Profit margin
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
attached in ss htnakx for the help
appreciated it
j2
t2ji
g
2igi
ll
arrow_forward
QUESTION 13
Nancy is employed by a large corporation as a sales representative. She is paid a salary of $70,000 in 2023.
She is required to have a home office and she estimates that her work related use at 375 square feet of her
1,500 square foot house. Total expenses for 2023 were as follows:
Mortgage payments (40% principal, 60% interest)
Home owner's insurance
Utilities
Roof repair
Municipal property tax
$24,000
900
1,500
800
5,000
As Nancy's compensation does not include any commissions, she is unable to claim some of these expenses
as an employment expense. If instead, her compensation of $70,000 was in the form of commissions, she
would be able to claim extra employment expenses of:
$1,675.
O $1,475.
O $5,075.
O $3,600.
arrow_forward
1. Compute the cost of the new building on December 31, 2021 and June 30, 2022.
2. Compute the interest expense for 2021 and 2022
arrow_forward
Do not give image format
arrow_forward
3
arrow_forward
dont give answer in image format
arrow_forward
Problem 3:
Galore Company ventured into construction of a condominium in Makati which is rated as the largest state-of-
the-art structure.
The entity's board of directors decided that instead of selling the condominium, the entity would hold this
of earning rentals by letting out space to business executives in the area.
property for
purposes
The construction of the condominium was completed and the property was placed in service on January 1
2019.
The cost of the construction was P50,000,000. The useful life of the condominium is 25 years and its residual
value is P5,000,000.
An independent valuation expert provided the following fair value at each subsequent year-end:
55,000,000
53,000,000
60,000,000
December 31, 2019
December 31, 2020
December 31, 2021
Required:
Prepare all indicated entries for 2019, 2020 and 2021 assuming the investment property is accounted for under
the cost model and fair value model.
arrow_forward
A-7
arrow_forward
2. REAL sells certain building naming rights and advertising opportunities within the REAL campus
to various organizations. We have just received a cheque of $100,000 from "Sponsor A" in
December 2023 for a brand new 2-year sponsorship agreement that starts in January 2024. The
cheque amount covers the first 3 months and the remaining 21 months will be paid 100,000
every quarter until the end of the contract.
a. Please prepare the journal entries that are needed for December 2023.
b. Please prepare the journal entries that are needed for January 2024.
arrow_forward
8
arrow_forward
#9
Issue: Linda Tristan, assistant controller for Ag-Growth, Inc., a biotechnology firm, has concerns about the accounting analysis for the firm’s purchase of a land site and building from Hylite Corporation. The price for this package purchase was $1,800,000 cash. A memorandum from the controller, Greg Fister, stated that the journal entry for this purchase should debit Land for $1,350,000, debit Building for $450,000, and credit Cash for $1,800,000. The building, a used laboratory facility, is to be depreciated over 10 years with a zero salvage value.
The source documents supporting the transaction include two appraisals of the property, one done for Ag-Growth and one done for Hylite Corporation. The appraisal for Ag-Growth valued the land at $1,000,000 and the building at $500,000. The appraisal for Hylite Corporation (done by a different appraiser) valued the land at $1,500,000 and the building at $750,000. Negotiations between the two firms finally settled on an overall price…
arrow_forward
please dont give handwritten answer thank you
arrow_forward
Dinesh bhai
arrow_forward
Show the solution in good accounting form
arrow_forward
Show the solution in good accounting form
arrow_forward
Vinubhai
arrow_forward
SUBJECT: ENGINEERING ECONOMICS
NOTES: 2 DECIMAL ONLY
MUST BOX THE FINAL ANSWERS
SOLUTIONS MUST BE CLEAR AND UNDERSTANDABLE
MUST HAVE GIVEN, FORMULA TO BE USED, SOLUTIONS, ANSWER
QUESTION:
A commercial rental property is offered for sale and consists of a two-storey building in a business district of small city. A prospective purchaser estimated that if he buys his property he will hold it for about 10 years. He estimates that the average annual receipts from rentals during this period will be P70,000 and the average annual expenses for all purposes in connection with ownership and operation will amount to P27,000. He believes that the property can be sold for a net of P400,000 at the end of 10 years. He considers a minimum rate of return of 7%. On the basis of the above estimates, using the Annual Worth method, what price for this property would just permit him to recover his investment at 7% return?
arrow_forward
Answer the situation
arrow_forward
Please don't give image format
arrow_forward
12
Bridge City Consulting bought a building and the land on which it is located for $195,000 cash.
The land is estimated to represent 70 percent of the purchase price. The company paid $20,000
for building renovations before it was ready for use.
Part 1 of 2
Required:
5
polnts
2. Prepare the journal entry to record all expenditures. Assume that all transactions were for cash and they
occurred at the start of the year. (If no entry is required for a transaction/event, select "No Journal Entry
Required" in the first account field.)
еВook
Hint
View transaction list
Print
Journal entry worksheet
A
>
References
Record all expenditures for the land and buildings assuming all transactions
were paid for with cash and occurred at the start of the year.
Note: Enter debits before credits.
Transaction
General Journal
Debit
Credit
Record entry
Clear entry
View general journal
arrow_forward
On January 1, 2024, the Mason Manufacturing Company began construction of a building to be used as its office headquarters. The building was completed on September 30, 2025. Expenditures on the project were as follows:
January 1, 2024 $ 1,040,000March 1, 2024 810,000June 30, 2024 450,000October 1, 2024 700,000January 31, 2025 1,125,000April 30, 2025 1,440,000August 31, 2025 2,610,000On January 1, 2024, the company obtained a $3 million construction loan with a 10% interest rate. Assume the $3 million loan is not specifically tied to construction of the building. The loan was outstanding all of 2024 and 2025. The company’s other interest-bearing debt included two long-term notes of $5,900,000 and $7,900,000 with interest rates of 7% and 9%, respectively. Both notes were outstanding during all of 2024 and 2025. Interest is paid annually on all debt. The company’s fiscal year-end is December 31.
Required:Using the WEIGHTED-AVERAGE INTEREST METHOD, answer the following…
arrow_forward
Question #2:
You find an Offering Memorandum for a warehouse Property in your
neighborhood. The Asking Price is $750,000 and, according to the
Offering Memo, the property produces $4,375 in monthly Net
Operating Income.
arrow_forward
mmarly
>> All Bookmarks
Problem 6-42 (Algorithmic) (LO. 3)
Henrietta, the owner of a very successful hotel chain in the Southeast, is exploring the possibility of expanding the chain into a city in the
Northeast. She incurs $53,000 of expenses associated with this investigation. Based on the regulatory environment for hotels in the city,
she decides not to expand. During the year, she also investigates opening a restaurant that will be part of a national restaurant chain. Her
expenses for this are $53,000. She proceeds with opening the restaurant, and it begins operations on May 1.
Determine the amount that Henrietta can deduct in the current year for investigating these two businesses.
In your computations, round the per-month amount to two decimal places then use rounded amount in subsequent
computations. Enter your final answers to the nearest whole dollar.
a. The deductible amount of investigation expenses related to expansion of her hotel chain into another city: $
b. The…
arrow_forward
kindly answer 1 and 2 question thank you
arrow_forward
The question number 1 I already aswered, please send me just the 2 question.
Mack Company, HappyDay’s branch, plans to invest $50,000 in land that will
produce annual rent revenue equal to 15 percent of the investment, starting
on January 1, Year 3. The revenue will be collected in cash at the end of each year,
starting December 31, Year 3. Mack can obtain the cash necessary to purchase the
land from two sources. Funds can be obtained by issuing $50,000 of 10 percent,
five-year bonds at their face amount. Interest due on the bonds is payable on
December 31 of each year with the first payment due on December 31, 2021.
Alternatively, the $50,000 needed to invest in land can be obtained from equity
financing. In this case, the stockholders (holders of the equity) will be paid a $5,000
annual cash dividend. Mack Company is in a 30 percent income tax bracket.
1. Prepare an income statement and statement of cash flows for Mack Company…
arrow_forward
answer in text form please (without image)
arrow_forward
sh1
please help me T
Thankyou
arrow_forward
Please DO NOT USE TABLE BUT CLEARLY EXPLAIN YOUR SOLUTION
arrow_forward
Transactions for the first 3-month period of calendar year 2021 for Sta Cruz Branch of XYZ
Company.
1. Home Office put up a branch with initial investment of cash 400,000; and equipment
180,000, and furniture & fixtures, 100,000, both to be booked in the branch.
2. Home office purchased equipment for use by the branch and to be carried in the Home
Office books. Acquisition cost is 80,000.
3. Branch purchased 160,000 worth of merchandise for 50% cash and balance on account.
Delivery charge of 3,000 paid by the branch.
4. Home Office ordered office table and chairs worth 20,000 to be carried in branch books.
The branch paid cash for the items upon delivery directly to the branch. Delivery charge
of 800 was also paid by the branch.
5. Branch purchased computers and printers worth 110,000 for use of the branch and to
be booked in the Home Office.
6. Home Office transferred merchandise worth 320,000. Home Office paid for the freight
of 5,000 to be taken up in branch books.
7. Branch total…
arrow_forward
On January 1, 2024, the Mason Manufacturing Company began construction of a building to be used as its office headquarters. The
building was completed on September 30, 2025. Expenditures on the project were as follows:
January 1, 2024
March 1, 2024
June 30, 2024
October 1, 2024
January 31, 2025
April 30, 2025
August 31, 2025
$ 2,050,000
1,800,000
2,000,000
1,800,000
450,000
783,000
1,080,000
On January 1, 2024, the company obtained a $5,000,000 construction loan with a 9% interest rate. The loan was outstanding all of
2024 and 2025. The company's other interest-bearing debt included two long-term notes of $6,000,000 and $9,000,000 with interest
rates of 5% and 8%, respectively. Both notes were outstanding during all of 2024 and 2025. Interest is paid annually on all debt. The
company's fiscal year-end is December 31.
Required:
1. Calculate the amount of interest that Mason should capitalize in 2024 and 2025 using the specific interest method.
2. What is the total cost of the building?…
arrow_forward
CHOOSE THE LETTER OF ANSWER
Galore Company ventured into construction of a condominium in Makati which is rated as the largest state-of-the art structure. The board of directors decided that instead of selling the condominium, the entity would hold this property for purposes of earning rentals by leasing out space to business executives in the area. The construction of the condominium was completed and the property was placed in service on January 1, 2020. The cost of the condominium was P50,000,000. The useful life of the condominium is 25 years and the residual value is P5,000,000. An independent valuation expert provided the following fair value at each subsequent year-end:December 31, 2020 55,000,000December 31, 2021 53,000,000December 31, 2022 60,000,000
Under the cost model, what amount should be reported as annual depreciation of investment property? a. 1,800,000b. 2,000,000c. 2,200,000d. 0
under the fair Value model, what amount should be recognized as gain from change in fair…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Related Questions
- attached in ss htnakx for the help appreciated it j2 t2ji g 2igi llarrow_forwardQUESTION 13 Nancy is employed by a large corporation as a sales representative. She is paid a salary of $70,000 in 2023. She is required to have a home office and she estimates that her work related use at 375 square feet of her 1,500 square foot house. Total expenses for 2023 were as follows: Mortgage payments (40% principal, 60% interest) Home owner's insurance Utilities Roof repair Municipal property tax $24,000 900 1,500 800 5,000 As Nancy's compensation does not include any commissions, she is unable to claim some of these expenses as an employment expense. If instead, her compensation of $70,000 was in the form of commissions, she would be able to claim extra employment expenses of: $1,675. O $1,475. O $5,075. O $3,600.arrow_forward1. Compute the cost of the new building on December 31, 2021 and June 30, 2022. 2. Compute the interest expense for 2021 and 2022arrow_forward
- Problem 3: Galore Company ventured into construction of a condominium in Makati which is rated as the largest state-of- the-art structure. The entity's board of directors decided that instead of selling the condominium, the entity would hold this of earning rentals by letting out space to business executives in the area. property for purposes The construction of the condominium was completed and the property was placed in service on January 1 2019. The cost of the construction was P50,000,000. The useful life of the condominium is 25 years and its residual value is P5,000,000. An independent valuation expert provided the following fair value at each subsequent year-end: 55,000,000 53,000,000 60,000,000 December 31, 2019 December 31, 2020 December 31, 2021 Required: Prepare all indicated entries for 2019, 2020 and 2021 assuming the investment property is accounted for under the cost model and fair value model.arrow_forwardA-7arrow_forward2. REAL sells certain building naming rights and advertising opportunities within the REAL campus to various organizations. We have just received a cheque of $100,000 from "Sponsor A" in December 2023 for a brand new 2-year sponsorship agreement that starts in January 2024. The cheque amount covers the first 3 months and the remaining 21 months will be paid 100,000 every quarter until the end of the contract. a. Please prepare the journal entries that are needed for December 2023. b. Please prepare the journal entries that are needed for January 2024.arrow_forward
- 8arrow_forward#9 Issue: Linda Tristan, assistant controller for Ag-Growth, Inc., a biotechnology firm, has concerns about the accounting analysis for the firm’s purchase of a land site and building from Hylite Corporation. The price for this package purchase was $1,800,000 cash. A memorandum from the controller, Greg Fister, stated that the journal entry for this purchase should debit Land for $1,350,000, debit Building for $450,000, and credit Cash for $1,800,000. The building, a used laboratory facility, is to be depreciated over 10 years with a zero salvage value. The source documents supporting the transaction include two appraisals of the property, one done for Ag-Growth and one done for Hylite Corporation. The appraisal for Ag-Growth valued the land at $1,000,000 and the building at $500,000. The appraisal for Hylite Corporation (done by a different appraiser) valued the land at $1,500,000 and the building at $750,000. Negotiations between the two firms finally settled on an overall price…arrow_forwardplease dont give handwritten answer thank youarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning