Question
RedInc. a publicly traded software company wishes to prepare a budgeted income statement for December 31, 2020. They project sales for 2020 will be twice
RedInc. a publicly traded software company wishes to prepare a budgeted income statement for December 31, 2020. They project sales for 2020 will be twice as large as the 2019 sales (sales grew to $343,750 in 2019). The following additional information has also been collected
- Merchandise/Inventory costs are estimated to be 20 % of annual sales
- Selling and Admin costs are 30% of annual sales
- Total depreciation for the year will be $110, 000
- Tax rate: 35%
- Outstanding number of shares 68,750, Shares are trading at $17.50.
- Industry Averages: Debt Ratio: 56% R.O.A: 12.5%, R.O.E. 14%, E.P.S $1.03
Complete the following budgeted income statement (10 MARKS)
Budgeted Income Statement | December 2020 |
Sales |
|
Merchandise/Inventory costs |
|
Selling and Admin costs |
|
Total Cost | |
Depreciation | 110, 000 |
Net Income before Taxes (NIBT) |
|
Taxes (35%) |
|
Net Income after Taxes (NIAT) |
|
Calculations 10 MarkS - For 2020 (ONE MARK PER CALCULATION 1- 8,-- 2 marks for Qs 9)
- The projected sales for RedInc :
- Projected Selling and Admin costs for are:
- Merchandise/Inventory costs are estimated
- The total cost:
- The projected Net income before taxes for is:
- Projected taxes are :
- Projected Net income after taxes is
- Projected Earnings Per Share for RedInc is:
- Shareholders Equity is :
Using the RedInc information and calculations, complete the following short answers (20 Marks)
- How much, if any, additional financing will RedInc need in December 2020? Explain ( 2 marks)
- IF additional financing is required which of the three activities within the Cash flow would be impacted and explain if it would be an outflow or inflow (explain). (4 marks)
- A. IF RedInc. was in a negative cash position and wanted to raise capital via Bond Issuance instead equity financing explain the advantages of doing so. (3 marks)
3 b. Assume, REDInc issued bonds with a coupon rated of 18%, did they achieve financial leverage (hint- refer to their ROE)-- Explain( 2 marks)
3c. Assume, REDInc issued bonds with a coupon rated of 18%, and the maket rate is 12 %, will the bond be sold at a premium or discount -- Explain (2 marks)
- Calculate the ROE and comment how it compares relative to the industry ROE average if the industry benchmark is 14% (3 marks)
- What is the purpose (s) of a cash budget? ( 4 marks)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started