Determine the amount of external financing needed

Reference no: EM1358037

Introduction to Finance
Week 5 - Numerical Exercises

S. No. Problems
1 Given the following data for Gary and Co (Millions of Dollars):

Balance Sheet Dec 31 200X

Cash $45
Accounts Payables $45
Marketable Securities 33
Notes Payables 45
Receivables 66
Other Current liabilities 21
Inventory 159
Total Current liabilities $111
Total Current Assets 303
Long term debt 24
Total liabilities $135
Net Fixed Assets 147
Common Stock 114
Total Assets $450
Retained Earnings 201
Total stockholders' equity 315
Total liabilities and equity 450

Income Statement Year 200X

Net sales $795
Cost of goods sold 660
Gross profit 135
Selling expenses 73.5
Depreciation 12
EBIT 49.5
Interest expense 4.5
EBT 45
Taxes (40% 18
Net Income 27

Calculate the following ratios:

Ratio Industry Average
Current ratio
Times interest earned
DSO
Inventory Turnover
Sales/Total Assets
Profit margin on sales
Return on Total Assets
Return on Common Equity

2 Given the compressed version of balance sheet and income statement; estimate the amount of external financing needed to increase sales by 20% next year. (use percentage of sales method)
(Dividend payout is 50%) $2,000

3 A firm has outstanding receivables of $125,000. Its credit terms are net 30. If during the past three months credit sales are $100,000, $105,000 and $60,000 how many days of sales are outstanding as receivables?

4 Given the following data develop weekly cash budget Minimum cash required is $50 and the beginning cash balance is $100.

5 Given the following data :
Days inventory = 103 days; Days receivables = 41 days and Days payables = 81 days
Calculate the cash conversion cycle and operating cycle

6 Calculate the cost of trade credit given terms of 3/20 net 60

7 A firm issues $1,000,000 of commercial paper with a maturity of 60 days and a discount rate of 5%. The paper is sold through a dealer who charges 0.25% What is the effective cost of issuing the commercial paper?

Reference no: EM1358037

Questions Cloud

Write a single line for body of constructor to create object : Create the constructor Orb(int xSpeed, int ySpeed). Write a single line for the body of the constructor,which creates a new Velocity object.

Causative factors of schizophrenia : Discuss two of the causative factors of schizophrenia. Examine the success of one treatment approach for this disorder.

Independent contractors or contingent employees : Show the advantages and disadvantages of independent contractors and contingent employees and describe the impact on operations, particularly production and efficiency.

Explain i agree that a company needs to stop layoffs : Explain I agree that a company needs to stop layoffs and consider their current employees important assets to the company

Determine the amount of external financing needed : Given the compressed version of balance sheet and income statement; determine the amount of external financing needed to increase sales by twenty percent next year.

Illustrate what is the maximum amount he or she would pay : Illustrate what is the maximum amount he or she would pay for insurance against a 50 percent chance of losing 3,600.

Cognitive and pharmocological treatment : What is an alternative therapeutic treatment for Schzophrenia outside of cognitive and pharmocological treatment?

Fasb codification-inventory research : What is the formal definition in the glossary of the term "Inventory?" What is the Codification topic number for inventory? What types of entities are not covered by the guidance in the Inventory Topic? (Provide the Codification reference for your ..

How much force pulls forward on the rope : A 23 kg body is moving in the direction of the positive x axis with a speed of 292 m/s when, owing to an internal explosion, it breaks into three pieces.

User Account

All Pages