On February 1, 2021, Arrow Construction Company entered into a three-year construction contract to build a bridge for a price of $8,330,000. During 2021, costs of $2,110,000 were incurred with estimated costs of $4,110,000 yet to be incurred. Billings of $2,610,000 were sent, and cash collected was $2,360,000.

In 2022, costs incurred were $2,610,000 with remaining costs estimated to be $3,765,000. 2022 billings were $2,860,000 and $2,585,000 cash was collected. The project was completed in 2023 after additional costs of $3,910,000 were incurred. The company’s fiscal year-end is December 31. Arrow recognizes revenue over time according to percentage of completion.

Required:
1. Compute the amount of revenue and gross profit or loss to be recognized in 2021, 2022, and 2023 using the percentage of completion method.
2a. Prepare journal entries for 2021 to record the transactions described (credit "various accounts" for construction costs incurred).
2b. Prepare journal entries for 2022 to record the transactions described (credit "various accounts" for construction costs incurred).
3a. Prepare a partial balance sheet to show the presentation of the project as of December 31, 2021.
3b. Prepare a partial balance sheet to show the presentation of the project as of December 31, 2022.

On February 1, 2021, Arrow Construction Company entered into a three-year construction contract to build a bridge for a price of $8,150,000. During 2021, costs of $2,050,000 were incurred with estimated costs of $4,050,000 yet to be incurred. Billings of $2,550,000 were sent, and cash collected was $2,300,000. In 2022, costs incurred were $2,550,000 with remaining costs estimated to be $3,675,000. 2022 billings were $2,800,000 and $2,525,000 cash was collected. The project was completed in 2023 after additional costs of $3,850,000 were incurred. The company’s fiscal year-end is December 31. Arrow recognizes revenue over time according to percentage of completion. Required: 1. Compute the amount of revenue and gross profit or loss to be recognized in 2021, 2022, and 2023 using the percentage of completion method. 2a. Prepare journal entries for 2021 to record the transactions described (credit "various accounts" for construction costs incurred). 2b. Prepare journal entries for 2022 to record the transactions described (credit "various accounts" for construction costs incurred). 3a. Prepare a partial balance sheet to show the presentation of the project as of December 31, 2021. 3b. Prepare a partial balance sheet to show the presentation of the project as of December 31, 2022.

On February 1, 2018, Arrow Construction Company entered into a three-year construction contract to build a bridge for a price of $8,000,000. During 2018, costs of $2,000,000 were incurred with estimated costs of $4,000,000 yet to be incurred. Billings of $2,500,000 were sent, and cash collected was $2,250,000.

In 2019, costs incurred were $2,500,000 with remaining costs estimated to be $3,600,000. 2019 billings were $2,750,000, and $2,475,000 cash was collected. The project was completed in 2020 after additional costs of $3,800,000 were incurred. The company’s fiscal year-end is December 31. Arrow recognizes revenue over time according to percentage of completion.

Required:
1. Compute the amount of revenue and gross profit or loss to be recognized in 2018, 2019, and 2020 using the percentage of completion method?
2a. Prepare journal entries for 2018 to record the transactions described (credit "various accounts" for construction costs incurred).
2b. Prepare journal entries for 2019 to record the transactions described (credit "various accounts" for construction costs incurred).
3a. Prepare a partial balance sheet to show the presentation of the project as of December 31, 2018.
3b. Prepare a partial balance sheet to show the presentation of the project as of December 31, 2019

On February 1, 2018, Arrow Construction Company entered into a three-year construction contract to build a bridge for a price of $8,540,000. During 2018, costs of $2,180,000 were incurred with estimated costs of $4,180,000 yet to be incurred. Billings of $2,680,000 were sent, and cash collected was $2,430,000. In 2019, costs incurred were $2,680,000 with remaining costs estimated to be $3,870,000. 2019 billings were $2,930,000 and $2,655,000 cash was collected. The project was completed in 2020 after additional costs of $3,980,000 were incurred. The company’s fiscal year-end is December 31. Arrow recognizes revenue over time according to percentage of completion. Required: 1. Compute the amount of revenue and gross profit or loss to be recognized in 2018, 2019, and 2020 using the percentage of completion method? 2a. Prepare journal entries for 2018 to record the transactions described (credit "various accounts" for construction costs incurred). 2b. Prepare journal entries for 2019 to record the transactions described (credit "various accounts" for construction costs incurred). 3a. Prepare a partial balance sheet to show the presentation of the project as of December 31, 2018. 3b. Prepare a partial balance sheet to show the presentation of the project as of December 31, 2019.

On February 1, 2018, Arrow Construction Company entered into a three-year construction contract to build a bridge for a price of $8,570,000. During 2018, costs of $2,190,000 were incurred with estimated costs of $4,190,000 yet to be incurred. Billings of $2,690,000 were sent, and cash collected was $2,440,000. In 2019, costs incurred were $2,690,000 with remaining costs estimated to be $3,885,000. 2019 billings were $2,940,000 and $2,665,000 cash was collected. The project was completed in 2020 after additional costs of $3,990,000 were incurred. The company’s fiscal year-end is December 31. Arrow recognizes revenue over time according to percentage of completion. Required: 1. Compute the amount of revenue and gross profit or loss to be recognized in 2018, 2019, and 2020 using the percentage of completion method? 2a. Prepare journal entries for 2018 to record the transactions described (credit "various accounts" for construction costs incurred). 2b. Prepare journal entries for 2019 to record the transactions described (credit "various accounts" for construction costs incurred). 3a. Prepare a partial balance sheet to show the presentation of the project as of December 31, 2018. 3b. Prepare a partial balance sheet to show the presentation of the project as of December 31, 2019.

On February 1, 2021, Arrow Construction Company entered into a three-year construction contract to build a bridge for a price of $8,480,000. During 2021, costs of $2,160,000 were incurred with estimated costs of $4,160,000 yet to be incurred. Billings of $2,660,000 were sent, and cash collected was $2,410,000.

In 2022, costs incurred were $2,660,000 with remaining costs estimated to be $3,840,000. 2022 billings were $2,910,000 and $2,635,000 cash was collected. The project was completed in 2023 after additional costs of $3,960,000 were incurred. The company’s fiscal year-end is December 31. Arrow recognizes revenue over time according to percentage of completion.

Required:
1. Compute the amount of revenue and gross profit or loss to be recognized in 2021, 2022, and 2023 using the percentage of completion method.
2a. Prepare journal entries for 2021 to record the transactions described (credit "various accounts" for construction costs incurred).
2b. Prepare journal entries for 2022 to record the transactions described (credit "various accounts" for construction costs incurred).
3a. Prepare a partial balance sheet to show the presentation of the project as of December 31, 2021.
3b. Prepare a partial balance sheet to show the presentation of the project as of December 31, 2022.

Case 2 (Special Order)

While Jurassic World is filled to capacity with tourists most of the year, the theme park experiences a lower number of customers during September and October. This is due to the fact that September and October are “rainy season” in Jurassic World’s location—the island of Isla Nublar, off the coast of Costa Rica.

To celebrate their sponsorship of the Pepsisaurus and the Tostidodon, PepsiCo is interested in holding a 3-day, 2-night corporate retreat for 5,000 of its employees at Jurassic world during September. PepsiCo has told Claire that they would pay Jurassic World $200 per employee. This would provide each employee with three days of park admission, three days of meal and drink vouchers, and two nights of lodging. Additionally, PepsiCo wants Jurassic World to treat its employees to behind-the-scenes tours of the park, which would cost a total of $50,000 to plan and facilitate. Due to the timing of the retreat, Jurassic World has ample capacity to host PepsiCo’s employees.

Claire knows that Jurassic World normally charges $850 per person for a 3-day, 2-night admission, lodging, and meal/drink vacation package. The per person cost for this package is 670, as shown below:

Most of the overhead is the fixed cost of running the theme park, and goes towards marketing, administration, dinosaur bioengineering, customer service, grounds keeping and maintenance, dinosaur food, raptor training, and disaster control. However, $35 is variable with respect to the number of customers in the theme park.

4. Determine the incremental revenue to Jurassic World if Claire accepts PepsiCo’s request. (1 point for the correct answer in the shaded box)

5. Determine the incremental cost to Jurassic World if Claire accepts PepsiCo’s request. (1 point for the correct answer in the shaded box)

6. Should Claire accept PepsiCo’s offer? Circle One. (1 point for the correct answer)

YES                                     NO

In January 2019, Miller Construction Corp. contracted to construct a building for $3,600,000. Construction started in early 2019 and was completed in 2020. The following additional information is available:

                                                                                          2019               2020

       Costs incurred...................................................... $1,458,000          $1,620,000

       Estimated costs to complete.................................. 1,560,000                         —

       Billed ……………………………………………….    1,700,000           1,900,000

       Collections during the year.................................... 1,440,000            2,160,000

Miller uses the percentage-of-completion method.

Instructions

Under the contract-based approach for percentage completion,

a) How much revenue should Miller report for 2019 and 2020?

b) Prepare all journal entries for 2019 and 2020 for this contract.

c)    What amounts would be presented on Miller’s December 31, 2019 Balance Sheet?

d)    What is the gross profit on the project for each of 2019 and 2020?

CREATE TABLE Hotel

(

roomNumber     INTEGER         PRIMARY KEY,

type                  CHAR(10)         NOT NULL,

rate                   INTEGER         NOT NULL,

--

CONSTRAINT IC1 CHECK (type IN ('suite', 'king', 'queen')),

CONSTRAINT IC2 CHECK (type <> 'suite' OR rate > 200),

CONSTRAINT IC3 CHECK (NOT (type = 'king' AND (rate < 80 OR rate > 220))),

CONSTRAINT IC4 CHECK (NOT (type = 'queen' AND rate >= 100))

);

which 8 of these inserts will be rejected only 8 are rejected

You have been appointed as the Finance Manager of Shangpuri Hotel Bhd. As a finance manager, you are evaluating Project PJ10B, an investment project, and TWO (2) other additional projects namely Project Bee and Project Cee. You are required to deliver a comprehensive report explaining the application of numerous financial practices for valuing investment projects for the board of directors’ strategic decision. Your finance department has forecasted cash flows to assess the viability of Project PJ10B, Project Bee, and Project Cee incorporating risk into the calculations.

Additional information:

1. Current dividend for Shangpuri Hotel Bhd’s ordinary stock is RM2.50 and dividend growth rate is 6%.

2. Shangpuri Hotel Bhd is planning to issue new ordinary stock at RM50 with a flotation cost of 9%.

3. The company’s bond is paying a 6% coupon payment. Corporate tax stood at 30%.

4. Shangri Hotel Bhd’s capital structure comprising of 40% debt and 60% common stock.

Information related to Project PJ10B

The cost of this investment is RM1,200,000.

The investment is estimated to effectively contribute for 3 years. Ignore the residual value.

Depreciation for the Project PJ10B is subject to a straight-line method.

Further, yearly cash inflow is estimated at $900,000 and cash outflow RM400,000 per year. Cash inflow and outflow in entitle for tax benefit.

Finance department estimates discount factor at 7.0%.

Information related to Project Bee

1. Cost of this investment is RM120,000

2. Finance department estimates discount factor at 8.0%.

3. Ignore tax and depreciation.

Information related to Project Cee

1. Cost of this investment is RM120,000

2. Finance department estimates discount factor at 8.0%.

3. Ignore tax and depreciation.

Required:

QUESTION 1

a. Calculate the cost of new ordinary stock for Shangpuri Hotel Bhd. The current dividend for the ordinary stock is $2.50 and the dividend is expected to grow at 6%.

b. Explain THREE (3) advantages and THREE (3) disadvantages of equity financing.

c. Calculate cost of debt for Shangpuri Hotel Bhd

d. Explain THREE (3) advantage and THREE (3) disadvantages of debt financing.

e. Calculate the weighted average cost of capital for the company

f. Explain FIVE (5) uses of WACC.

QUESTION 2

a. Calculate NPV for Project PJ10B based on discount factor of Shangpuri Hotel Bhd.

b. Calculate NPV for Project PJ10B based on WACC of Shangpuri Hotel Bhd.

c. Calculate IRR for Project PJ10B

d. Explain FIVE (5) conflicts between NPV and IRR

QUESTION 3

a. Calculate expected Annual Cash flow from Project Bee

b. Calculate expected Annual Cash flow from Project Cee

c. Calculate NPV and IRR from Project Bee assuming discount factor stood at 8% & Project Bee’s life span is 6 years.

d. Calculate NPV and IRR from Project Cee assuming discount factor stood at 8% & Project Cee’s life span is 6 years.

QUESTION 4

a. Provide overall recommendation to Shangpuri Hotel Bhd Board of Directors on the viability of

             i. Project PJ10B.

ii. Project Bee.

iii. Project Cee.

(15 marks

b. Prepare an executive summary