Purchase Solution

Estimate the amount of external financing

Not what you're looking for?

Ask Custom Question

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?

Attachments
Purchase this Solution

Solution Summary

This discuss the steps to estimate the amount of external financing

Solution Preview

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 ...

Purchase this Solution


Free BrainMass Quizzes
Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.