Week 6 SQT 6-1tlbr34p6n5v5_116utwnvo4eu9
xlsx
keyboard_arrow_up
School
Govt. I. T. I , Mudkhed, Dist. Nanded *
*We aren’t endorsed by this school
Course
125
Subject
Finance
Date
Nov 24, 2024
Type
xlsx
Pages
2
Uploaded by pawanstar
Week 6 - SQT 6
1
Balance Sheets
Stock &
Stock &
Stock
Debt
Debt
Total assets
12,000,000 12,000,000 12,000,000 Debt
6,000,000 6,000,000 Common stock
12,000,000 6,000,000 6,000,000 Total liabilities & equity
12,000,000 12,000,000 12,000,000 Assume interest rate of:
9%
12%
Complete the following income statements.
Income Statements
EBIT
2,500,000 2,500,000 2,500,000 Interest expense
540,000.00 720,000.00 Taxable income (EBT)
1,960,000 1,780,000 Income tax (40%)
1,000,000.00 784,000.00 712,000.00 Net income
Total tollars to investors
Return on Equity
Now Recalculate using tax rate of 10%
Income Statements
EBIT
2,500,000 2,500,000 2,500,000 Interest expense
Taxable income (EBT)
Income tax (10%)
Net income
Total tollars to investors
Return on Equity
What do the results tell you about financing and tax rates?
2
Calculate the after tax cost of debt assuming the interest rate is 9% and tax rate is:
a. 0%
b. 25%
c. 40%
3
Alpa Bravo Company has a target capital structure of 40% debt and 60% equity.
The firm has a tax rate of 35%, interest rate of 8% and cost of equity of 12%.
Calculate the firm's weighted average cost of capital (WACC).
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 Documents
Related Questions
Only EX 14-5 please and thank you!
arrow_forward
#9
Item
Prior year
Current year
Accounts payable
8,123.00
7,716.00
Accounts receivable
6,048.00
6,607.00
Accruals
997.00
1,500.00
Cash
???
???
Common Stock
10,094.00
11,603.00
COGS
12,653.00
18,393.00
Current portion long-term debt
4,911.00
5,090.00
Depreciation expense
2,500
2,763.00
Interest expense
733
417
Inventories
4,245.00
4,824.00
Long-term debt
14,141.00
13,226.00
Net fixed assets
51,826.00
54,004.00
Notes payable
4,339.00
9,940.00
Operating expenses (excl. depr.)
13,977
18,172
Retained earnings
28,688.00
30,532.00
Sales
35,119
45,044.00
Taxes
2,084
2,775
What is the firm's cash flow from financing?
Answer format: Number: Round to: 0 decimal places.
arrow_forward
#10
Item
Prior year
Current year
Accounts payable
8,123.00
7,716.00
Accounts receivable
6,048.00
6,607.00
Accruals
997.00
1,500.00
Cash
???
???
Common Stock
10,094.00
11,603.00
COGS
12,653.00
18,393.00
Current portion long-term debt
4,911.00
5,090.00
Depreciation expense
2,500
2,763.00
Interest expense
733
417
Inventories
4,245.00
4,824.00
Long-term debt
14,141.00
13,226.00
Net fixed assets
51,826.00
54,004.00
Notes payable
4,339.00
9,940.00
Operating expenses (excl. depr.)
13,977
18,172
Retained earnings
28,688.00
30,532.00
Sales
35,119
45,044.00
Taxes
2,084
2,775
What is the firm's total change in cash from the prior year to the current year?
Answer format: Number: Round to: 0 decimal places.
arrow_forward
20XX:
Unearned rent
Retained earnings (unrestricted)
Common stock, $5 par
Premium on bonds payable
Bonds payable
Additional paid-in capital on common stock
Treasury stock, at cost
Retained earnings restricted for plant expansion
Sinking fund for bond retirement
Required:
Prepare the shareholders' equity section of the balance sheet for Meyers.
$4,500
141,000
150,000
1,800
28,000
55,000
29,000
17,000
31,250
arrow_forward
Changes in Various Ratios
Presented below is selected information for Turner Company:
Sales revenue
Cost of goods sold
Interest expense
Income tax expense
Net income
Cash flow from operating activities
Capital expenditures
Accounts receivable (net), December 31
Inventory, December 31
Stockholders' equity, December 31
Total assets, December 31
2019
2018
$950,000 $850,000
575,000 545,000
20,000
20,000
27,000
30,000
65,000
55,000
70,000
60,000
45,000
45,000
126,000 120,000
196,000 160,000
450,000 400,000
750,000
675,000
Required
Calculate the following ratios for 2019. The 2018 results are given for comparative purposes.
Round answers to one decimal place. Use 365 days in a year.
2018
35.9%
8.3%
6.5%
1. Gross profit percentage
2. Return on assets
3. Return on sales
4. Return on common stockholders' equity
(no preferred stock was outstanding)
5. Accounts receivable turnover
6. Average collection period
13.9%
8.0
45.6 days
2019
0 %
0 %
0 %
0 %
0
0 days
arrow_forward
#6
Item
Prior year
Current year
Accounts payable
8,182.00
7,768.00
Accounts receivable
6,011.00
6,766.00
Accruals
Cash
Common Stock
COGS
Current portion long-term debt
Depreciation expense
Interest expense
Inventories
Long-term debt
1,022.00
1,542.00
???
???
11,535.00
12,370.00
12,726.00
18,265.00
4,989.00
5,013.00
2,500
2,833.00
733
417
4,158.00
4,820.00
14,080.00
14,452.00
Net fixed assets
51,720.00
54,916.00
Notes payable
4,306.00
9,860.00
Operating expenses (excl. depr.)
13,977
18,172
Retained earnings
28,006.00
29,332.00
Sales
35,119
47,524.00
Taxes
2,084
2,775
What is the firm's total change in cash from the prior year to the current year?
Submit
Answer format: Number: Round to: 0 decimal places.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Related Questions
- Only EX 14-5 please and thank you!arrow_forward#9 Item Prior year Current year Accounts payable 8,123.00 7,716.00 Accounts receivable 6,048.00 6,607.00 Accruals 997.00 1,500.00 Cash ??? ??? Common Stock 10,094.00 11,603.00 COGS 12,653.00 18,393.00 Current portion long-term debt 4,911.00 5,090.00 Depreciation expense 2,500 2,763.00 Interest expense 733 417 Inventories 4,245.00 4,824.00 Long-term debt 14,141.00 13,226.00 Net fixed assets 51,826.00 54,004.00 Notes payable 4,339.00 9,940.00 Operating expenses (excl. depr.) 13,977 18,172 Retained earnings 28,688.00 30,532.00 Sales 35,119 45,044.00 Taxes 2,084 2,775 What is the firm's cash flow from financing? Answer format: Number: Round to: 0 decimal places.arrow_forward#10 Item Prior year Current year Accounts payable 8,123.00 7,716.00 Accounts receivable 6,048.00 6,607.00 Accruals 997.00 1,500.00 Cash ??? ??? Common Stock 10,094.00 11,603.00 COGS 12,653.00 18,393.00 Current portion long-term debt 4,911.00 5,090.00 Depreciation expense 2,500 2,763.00 Interest expense 733 417 Inventories 4,245.00 4,824.00 Long-term debt 14,141.00 13,226.00 Net fixed assets 51,826.00 54,004.00 Notes payable 4,339.00 9,940.00 Operating expenses (excl. depr.) 13,977 18,172 Retained earnings 28,688.00 30,532.00 Sales 35,119 45,044.00 Taxes 2,084 2,775 What is the firm's total change in cash from the prior year to the current year? Answer format: Number: Round to: 0 decimal places.arrow_forward
- 20XX: Unearned rent Retained earnings (unrestricted) Common stock, $5 par Premium on bonds payable Bonds payable Additional paid-in capital on common stock Treasury stock, at cost Retained earnings restricted for plant expansion Sinking fund for bond retirement Required: Prepare the shareholders' equity section of the balance sheet for Meyers. $4,500 141,000 150,000 1,800 28,000 55,000 29,000 17,000 31,250arrow_forwardChanges in Various Ratios Presented below is selected information for Turner Company: Sales revenue Cost of goods sold Interest expense Income tax expense Net income Cash flow from operating activities Capital expenditures Accounts receivable (net), December 31 Inventory, December 31 Stockholders' equity, December 31 Total assets, December 31 2019 2018 $950,000 $850,000 575,000 545,000 20,000 20,000 27,000 30,000 65,000 55,000 70,000 60,000 45,000 45,000 126,000 120,000 196,000 160,000 450,000 400,000 750,000 675,000 Required Calculate the following ratios for 2019. The 2018 results are given for comparative purposes. Round answers to one decimal place. Use 365 days in a year. 2018 35.9% 8.3% 6.5% 1. Gross profit percentage 2. Return on assets 3. Return on sales 4. Return on common stockholders' equity (no preferred stock was outstanding) 5. Accounts receivable turnover 6. Average collection period 13.9% 8.0 45.6 days 2019 0 % 0 % 0 % 0 % 0 0 daysarrow_forward#6 Item Prior year Current year Accounts payable 8,182.00 7,768.00 Accounts receivable 6,011.00 6,766.00 Accruals Cash Common Stock COGS Current portion long-term debt Depreciation expense Interest expense Inventories Long-term debt 1,022.00 1,542.00 ??? ??? 11,535.00 12,370.00 12,726.00 18,265.00 4,989.00 5,013.00 2,500 2,833.00 733 417 4,158.00 4,820.00 14,080.00 14,452.00 Net fixed assets 51,720.00 54,916.00 Notes payable 4,306.00 9,860.00 Operating expenses (excl. depr.) 13,977 18,172 Retained earnings 28,006.00 29,332.00 Sales 35,119 47,524.00 Taxes 2,084 2,775 What is the firm's total change in cash from the prior year to the current year? Submit Answer format: Number: Round to: 0 decimal places.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning