Final Exam Take Home Final Shane McClellan
.docx
keyboard_arrow_up
School
Western Michigan University *
*We aren’t endorsed by this school
Course
6005
Subject
Business
Date
Feb 20, 2024
Type
docx
Pages
3
Uploaded by DeaconSnake481
Memorandum
To: Karen Brown, CEO From: Shane McClellan, Accountant Date: October 9, 2023 Subject: Financial Analysis and Recommendations – Pleasanton Studios Objective:
To provide Karen Brown with a financial analysis and recommendations to help her make decisions about the company's three divisions.
Analysis:
Investment in the New Animation Studio
The NPV of the new animation studio project is $1,027,269. The IRR of the project is 15%. Since the IRR is greater than the company's cost of capital of 12%, I recommend that the company invest in the
new animation studio.
Closing the Parks Division
If the Parks division is closed, the company's operating income will increase by $1,246,450. However,
the company will still have to pay the $1,680,000 mortgage payment on the land and buildings for the park. Therefore, the company's net income will decrease by $433,550 if the Parks division is closed.
I recommend that the company close the Parks division. The division has been unprofitable for the past two years and closing it will improve the company's overall profitability.
Evaluation of Angela Imanah’s Filed Complaint
Streaming Division Manager, Angela Imanah's complaint might come with some validity behind it, especially if the bonus structure inherently favors older divisions or doesn't reward rapid growth. Based off her complaint, there is three areas of concern she asserts, below they are displayed and our evaluation of their validity:
-Potential Growth and Performance: The Streaming division has experienced steady growth (20% annually since 2018). If Angela's management has directly contributed to this growth, her complaint about her bonus compared to Joe Freeman's (from the Entertainment division) might be valid.
-Bonus Structure: Angela's concern revolves around the bonus payout structure, which seems to favor divisions with older assets (like Entertainment) over newer ones (like Streaming). If the bonus structure is heavily based on asset age or some other factor that inherently disadvantages newer divisions, her complaint is valid.
-Asset Acquisition: Angela mentions that the Streaming division's assets were acquired more recently.
If the bonus structure is influenced by asset depreciation or some other measure of use, as mentioned, it could inherently disadvantage newer divisions, making Angela's complaint valid.
Conclusion
I recommend that the company invest in the new animation studio and close the Parks division; it is currently unprofitable and closing it will increase the company's net income by $2,181,287. These decisions will improve the company's overall profitability and long-term success.
Appendices
Appendix A:
Full Segmented Income Statement
The following segmented income statement provided an analyzed summary of this year's company
performance, with negative operating income tax calculated for the Parks division:
Segmented Income Statement
Division
Sales
COGS
Gross Margin
Allocated
Overhead
Selling, Admin,
and Marketing
Operating Income
Tax Expense
Divisional Income
Entertainment
$54,583,52
0
$40,257,310
$14,326,21
0
$1,500,000
$3,259,520
$9,566,690
$2,391,673
$7,175,017
Streaming
$30,184,57
0
$22,020,695
$8,163,875
$1,500,000
$944,620
$5,719,255
$1,429,814
$4,289,441
Parks
$7,564,270
$3,698,928
$3,865,342
$1,500,000
$231,900
-$997,160
$249,290
-$1,246,450
Overall
$92,332,36
0
$65,976,933
$26,355,42
7
$4,500,000
$4,436,040
$14,328,464
$4,070,777
$10,257,687
Appendix B
: Below is the determined Return on Investment, Residual Income, and Economic Value
Added for each division:
Appendix C
: NPV Calculation for the New Animation Studio
ROI, Residual Income, and EVA by Division
Division
ROI (%)
Residual Income ($M)
EVA ($M)
Entertainment
32.97
1.14
1.06
Streaming
22.23
0.78
0.73
Parks
-23.72
-0.25
-0.31
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
Owe
Subject: acounting
arrow_forward
A construction company Y is considering to participate in the tendering process forbuilding a toll bridge. The duration of the construction project is 5 years. The successfultenderer is allowed to collect toll from the bridge users after the completion of the projectand subsequently will be responsible for maintaining the bridge. The expected cash flowtransactions from this project are as follows:• Receive bank loan of RM 2,000,000 now• Annual material expenses of RM 200,000 in year 1 and expected to increase by RM20,000 per year until year 5• Annual bridge maintenance cost of RM 70,000 from year 6 until end of bridge life• Annual bank loan payment of RM 500,000 starting from the first year until at theend of year 10• Progress payment received from the government: RM 4,000,000 (end of year 3)and RM 8,000,000 (end of year 5)• Toll revenue of RM 500,000 per year from year 6 until year 10
a) Construct cash flow diagram to summarize the above transactions.
b) Another company is interested…
arrow_forward
Pls help ASAP for both
arrow_forward
Subject: Procurement & sourcing
Q): Under which H.S Code Cherat Packaging Ltd. clear their raw material of Granules & Kraft paper?
Q): What is the total procurement expenses of 2022 & 2021 of Cherat packaging?
arrow_forward
Question 1: Salalalh Methanol company management is considering three competing
investment Projects A, B & C
Year
Initial Investment
1
2
3
4
Assume a discount Rate of 5.45 %
Project A
Project B
12000
4150
Project C
12000
5225
12000
1200
3100
3800
4600
5260
7360
9460
8250
9275
9300
Use the information above and help the management in choosing the most desirable
Project using Payback period, Discounted payback Net Present value and
Profitability Index. Out of the four methods which is considered to be the most
desirable. Explain
arrow_forward
None
arrow_forward
Fine-Carpets Ltd. reports the following free cash flows from its recent project: - 3,000,000 + 1,160,000 + 1,273,500 + 1,492,650 What is the project's NPV if the cost of its capital is 12%? Question 2Answer a. $113,379.48 b. $311,937.48 c. $131,379.48 d. $113,397.48 e. $113,973.48
arrow_forward
Lorraine has received a lump sum of R500 000.00 from her retirement fund. She intends to usethese funds to start a student accommodation business. In order to start this business, Lorrainewould need approximately R1 million, funds are needed for building the students accommodationapartments and to register with various regulatory bodies. She has to source additional funding inorder to realise this dream. In the business plan, Lorraine has outlined the following:• Accommodation will be offered ONLY to students in Cape Town, Johannesburg,Mpumalanga and Polokwane.• ONLY females will be approved to reside in these houses, between the age of 18 - 35.• Marketing of the business will be done on community Radio stations only at the fourmentioned cities.• It is going to be a family business, Friends and relatives are in support of the idea but arenot able to support the business financially
There are three types of Market coverage. Explain the type of market coverageapplicable to Lorraine’s…
arrow_forward
Question 4:
You have $1,000,000 to invest in a portfolio which will have the same
risk as the market portfolio. Keeping this in mind, complete the
following table:
Asset
Table 3
Investment
Beta
Stock A $200,000
0.8
Stock B $100,000
Stock C
1.3
1.5
Risk free asset
Total investment $1,000,000
Hint: Start by computing the weight for stock C
arrow_forward
1.What is the point at which an owner can begin to occupy a building or use it for its intended purpose?
At the end of the warranty period
After final completion
When the payment bond is terminated
After substantial completion
2.What is used to determine periodic payment amounts on unit price contracts?
Submitted invoices, receipts, and timesheets plus the contractor's fee.
A fixed, monthly installment negotiated at the start of the project.
Schedule of Values and percentage completion on each pay item
Unit prices originally bid and quantities measured.
arrow_forward
4. Using a discounted rate of 12 percent,
INITIAL COST
NET CASH FLOW
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
PROJECT A (BROILER)
K100,000
(20,000)
10,000
40.000
40.000
150.000
PROJECT B (LAYERS)
K100,000
33,000
33,000
33,000
33,000
33,000
a. Determine the net present value of project A and B
b. Calculate the IRR on mutually exclusive investment of project A and B.
C. Which project must the farm undertake and why?
arrow_forward
The FWO has just made the winning bid of 54 million Rs. to construct a new Building.
Company has assigned you to this project to help ensure that it stays on schedule. The
contract includes the following provisions:
• A penalty of 300,0000 Rs. if Project has not completed construction by the deadline 47
weeks.
• To provide additional incentive for speedy construction, a bonus of 150,0000 Rs. will be
paid to if the building is completed within 40 weeks.
Estimated
Duration
Crew size
Activity Activity Description
Immediate
Predecessors
(Weeks)
Norm,
Min.
A
Excavate
2
B Lay the foundation
A
4
3
Put up the rough
в
10
6
3
wall
D
Put up the roof
C
6
3
Exterior plumbing
C
4
2
Interior plumbing
3
G
Exterior siding
D
3
Exterior painting
E, G
9
3
Electrical work
C
3
1
J
Put up the
F, I
4
wallboard
K
install the flooring
J
4
4
2
L
Interior painting
J
4
2
Exterior fixtures
Interior fixtures
M
H
2
1
N
K, L
6
1
Develop a comprehensive plan based on AOA or AON diagram that includes answers to the…
arrow_forward
The G&E Company is preparing a bid to build the new 47,000-seat Shoreline baseball stadium. The construction must start on Jan 01 2022, and be completed in time for the finals of the 2024 season. A penalty clause of $250,000 per week of delay beyond October 1st, 2024 is written into the contract.
George Earnings, the president of the company, expressed optimism at obtaining the contract and revealed that the company could net as much as $3 million on the project. He also said if they succeed, the prospects of future projects are bright since there is a projected renaissance in building classic ballparks with modern luxury boxes.
ID
Activity
Duration
Predecessor(s)
1
Baseball Stadium
2
Clear stadium site
70 days
—
3
Demolish building
30 days
2
4
Set up construction site
70 days
3
5
Drive support piling
120 days
4
6
Pour lower concrete bowl
120 days
5
7
Pour main concourse
120 days
6
8…
arrow_forward
The Town of Broomville, along with local arts and athletic groups, decided to erect a
new community centre for sports, music, and theatre. The total estimated cost was
$18,000,000 in April. Jane Borkus, president and CEO of the largest local industry.
Autotech, promised to match every dollar raised through other donors, up to
$9,000,000. Both she and the delighted town mayor, Geoff Johns, made the
announcement over the local television station and in a joint statement in the town's
newspaper. Borkus said the deadline would be 12 months. The following January,
the campaign was proceeding extremely well; other donors had pledges $5,500,000
and Borkus presented a cheque for $4,000,000 as Autotech's "down payment and
pledge of good will." Unfortunately, in March, Autotech lost its major contract to
supply car parts to one of the big three auto manufacturers. Anticipating a large loss
at year's end, Borkus withdrew the pledge and asked for the return of the down
payment. Broomville will…
arrow_forward
Please don't provide answer in image format thank you.
arrow_forward
Recommendations for North East Link project in Victoria.
Recommendations on how to solve budget blowout.
Please include references.
arrow_forward
Basic scenario analysis Aluminum Projects is in the process of evaluating two newaluminum cutting machines with the intention of purchasing one of them. The firm’sfinancial analysts have developed pessimistic, most likely, and optimistic estimates ofthe annual cash inflows for the two machines, which are shown in the following table.
a. Determine the range of annual cash inflows for each machine.b. Assume that firm’s cost of capital is 10% and that both machines have 12-yearlives. Construct a table similar to this one for the NPVs for each machine.Include the range of NPVs for each machine.c. Based on the range of the cash flows and the NPVs of each machine, whichmachine should be acquired?d. Which machine should the firm invest in if it is not willing to take risks? Why?
arrow_forward
Assignment No. 11(Decision Analysis)Answer 3 c, d
arrow_forward
EX2-7 (Algo) The Custom Bike Company...
The Custom Bike Company has set up a weighted scoring matrix for evaluation of potential projects. Following are five projects under
consideration.
Criteria
Weight
Project 1
Project 2
Project 3
Project 4
Project 5
Project 1
Project 2
Project 3
Project 4
Project 5
Strong sponsor
2
2
4
6
=
10
8
Supports business
Which project would you choose first?
strategy
3
3
5
4
2
0
10% of sales from
Urgency new products Competition Fill market gap
1
4
0
2
1
1
7
Using the scoring matrix above, what score would you give to each project?
3
2
5
1
8
5
7
6
10
1
10
1
5
6
6
1
1
arrow_forward
10.4 The staff of Jefferson Medical Services has estimated the following net cash flows
for a food services operation that it may open in its outpatient clinic:
Year
Expected Net Cash Flow
0
($100,000)
1
30,000
2
30,000
3
30,000
4
30,000
5
30,000
5 (salvage value)
20,000
The time 0 cash flow is the net investment outlay, while the final amount is the terminal cash flow. (The clinic is expected to move to a new building in five years.) All other flows represent net operating cash flows. Jefferson’s corporate cost of capital is 10 percent.
What is the project’s IRR?
Assuming the project has average risk, what is its NPV?
Now, assume that the operating cash flows in years 1 through 5 could be as low as $20,000 or as high as $40,000. Furthermore, the salvage value cash flow at the end of year 5 could be as low as $0 or as high as $30,000. What are the worst-case and best-case IRRs? The worst-case and best-case NPVs?
arrow_forward
Preliminary plans are underway for construction of a new stadium for a major league baseball team. City officials question the number and profitability of the luxury corporate boxes planned for the upper deck of the stadium. Corporations and selected individuals may purchase a box for $300,000. The fixed construction cost for the upper-deck area is estimated to be $4,500,000, with a variable cost of $150,000 for each box constructed.
a. What is the breakeven point for the number of luxury boxes in the new stadium?
b. Preliminary drawings for the stadium show that space is available for the construction of up to 50 luxury boxes. Promoters indicate that buyers are available and that all 50 could be sold if constructed. What is your recommendation concerning the construction of luxury boxes? What profit is anticipated?
arrow_forward
determine the exact simple interest and future worth of 1,500,000 invested for the period from march 16 2020 to feb 28 2022 if the rate interest is 13%
exact simple interest
future worth
arrow_forward
Multiple choice
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Related Questions
- Owe Subject: acountingarrow_forwardA construction company Y is considering to participate in the tendering process forbuilding a toll bridge. The duration of the construction project is 5 years. The successfultenderer is allowed to collect toll from the bridge users after the completion of the projectand subsequently will be responsible for maintaining the bridge. The expected cash flowtransactions from this project are as follows:• Receive bank loan of RM 2,000,000 now• Annual material expenses of RM 200,000 in year 1 and expected to increase by RM20,000 per year until year 5• Annual bridge maintenance cost of RM 70,000 from year 6 until end of bridge life• Annual bank loan payment of RM 500,000 starting from the first year until at theend of year 10• Progress payment received from the government: RM 4,000,000 (end of year 3)and RM 8,000,000 (end of year 5)• Toll revenue of RM 500,000 per year from year 6 until year 10 a) Construct cash flow diagram to summarize the above transactions. b) Another company is interested…arrow_forwardPls help ASAP for botharrow_forward
- Subject: Procurement & sourcing Q): Under which H.S Code Cherat Packaging Ltd. clear their raw material of Granules & Kraft paper? Q): What is the total procurement expenses of 2022 & 2021 of Cherat packaging?arrow_forwardQuestion 1: Salalalh Methanol company management is considering three competing investment Projects A, B & C Year Initial Investment 1 2 3 4 Assume a discount Rate of 5.45 % Project A Project B 12000 4150 Project C 12000 5225 12000 1200 3100 3800 4600 5260 7360 9460 8250 9275 9300 Use the information above and help the management in choosing the most desirable Project using Payback period, Discounted payback Net Present value and Profitability Index. Out of the four methods which is considered to be the most desirable. Explainarrow_forwardNonearrow_forward
- Fine-Carpets Ltd. reports the following free cash flows from its recent project: - 3,000,000 + 1,160,000 + 1,273,500 + 1,492,650 What is the project's NPV if the cost of its capital is 12%? Question 2Answer a. $113,379.48 b. $311,937.48 c. $131,379.48 d. $113,397.48 e. $113,973.48arrow_forwardLorraine has received a lump sum of R500 000.00 from her retirement fund. She intends to usethese funds to start a student accommodation business. In order to start this business, Lorrainewould need approximately R1 million, funds are needed for building the students accommodationapartments and to register with various regulatory bodies. She has to source additional funding inorder to realise this dream. In the business plan, Lorraine has outlined the following:• Accommodation will be offered ONLY to students in Cape Town, Johannesburg,Mpumalanga and Polokwane.• ONLY females will be approved to reside in these houses, between the age of 18 - 35.• Marketing of the business will be done on community Radio stations only at the fourmentioned cities.• It is going to be a family business, Friends and relatives are in support of the idea but arenot able to support the business financially There are three types of Market coverage. Explain the type of market coverageapplicable to Lorraine’s…arrow_forwardQuestion 4: You have $1,000,000 to invest in a portfolio which will have the same risk as the market portfolio. Keeping this in mind, complete the following table: Asset Table 3 Investment Beta Stock A $200,000 0.8 Stock B $100,000 Stock C 1.3 1.5 Risk free asset Total investment $1,000,000 Hint: Start by computing the weight for stock Carrow_forward
- 1.What is the point at which an owner can begin to occupy a building or use it for its intended purpose? At the end of the warranty period After final completion When the payment bond is terminated After substantial completion 2.What is used to determine periodic payment amounts on unit price contracts? Submitted invoices, receipts, and timesheets plus the contractor's fee. A fixed, monthly installment negotiated at the start of the project. Schedule of Values and percentage completion on each pay item Unit prices originally bid and quantities measured.arrow_forward4. Using a discounted rate of 12 percent, INITIAL COST NET CASH FLOW YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 PROJECT A (BROILER) K100,000 (20,000) 10,000 40.000 40.000 150.000 PROJECT B (LAYERS) K100,000 33,000 33,000 33,000 33,000 33,000 a. Determine the net present value of project A and B b. Calculate the IRR on mutually exclusive investment of project A and B. C. Which project must the farm undertake and why?arrow_forwardThe FWO has just made the winning bid of 54 million Rs. to construct a new Building. Company has assigned you to this project to help ensure that it stays on schedule. The contract includes the following provisions: • A penalty of 300,0000 Rs. if Project has not completed construction by the deadline 47 weeks. • To provide additional incentive for speedy construction, a bonus of 150,0000 Rs. will be paid to if the building is completed within 40 weeks. Estimated Duration Crew size Activity Activity Description Immediate Predecessors (Weeks) Norm, Min. A Excavate 2 B Lay the foundation A 4 3 Put up the rough в 10 6 3 wall D Put up the roof C 6 3 Exterior plumbing C 4 2 Interior plumbing 3 G Exterior siding D 3 Exterior painting E, G 9 3 Electrical work C 3 1 J Put up the F, I 4 wallboard K install the flooring J 4 4 2 L Interior painting J 4 2 Exterior fixtures Interior fixtures M H 2 1 N K, L 6 1 Develop a comprehensive plan based on AOA or AON diagram that includes answers to the…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning