Question

In: Accounting

I need Answers to Question from P - V! I know it's a lot but they...

I need Answers to Question from P - V!

I know it's a lot but they are all small questions related to the same case so I didn't know how to split it into multiple questions. I would really appreciate the help, as I need a way to compare my answers.

Dallas & Associates Financial Statement Preparation & Analysis

You have been hired as a senior financial analyst for Dallas and Associates and you are in charge of preparing the financial statements and presenting an annual analysis at the board meeting.

Overview of Dallas & Associate’s Balance Sheet

The assets of Dallas & Associates in 2017 have both current assets and net plant and equipment. It has total assets of $ 7.5 million and net plan and equipment equals $5 million. Dallas & Associate’s only finances with $2.5 million long-term debt, $500,000 notes payable and total common equity of $3.5 million. The firm does have $400,000 accounts payable and $600,000 accruals on its balance sheet. Now assume the firm’s current assets consist entirely of cash and cash equivalence, account receivables and inventories. If it has 1.5 million cash and cash equivalents and $400,000 account receivables.

Dallas & Associates Income Statement in 2017 (dollars are in millions)

Sales 15

Operating costs excluding depreciation and amortization

5
EBITDA 10

Depreciation & Amortization

0.6
EBIT 9.4
Interest 0.4
EBT 9

Taxes (40%)

3.6

Net Income

Cash Dividends

5.4

2.0

Use the above information to answer the following questions. Make sure to include the calculation steps/ formula.

Questions:

a. Prepare the balance sheet.

Total Assets

Liabilities & Shareholder’s Equity

b. What is the amount of total liabilities and equity that appears on the firm’s balance?

c. What is the amount of current assets?

d. What is the balance of current liabilities?

e. What is the amount of company’s inventory?

f. What is the amount of total liabilities?

g. What is the amount of total debt?

h. What is the amount of total capital?

i. What is the amount of net working capital?

j. What is the amount of net operating working capital?

k. If by the end of 2017, the retained earnings of John and Jon is $2.5 million, what is the amount of paid-in capital?

l. If John & Jon decides to purchase $500,000 market securities by using its cash, how does this action would affect its current asset position?

m. As the Income of Statement shows in 2017 Dallas associates actually gave out $2 million cash dividends, what is the amount of retained earnings?

n. What is the amount of operating income?

o. What are the operating margin and the profit margin?

p. What is the average length of time that Dallas associates must wait after making a sale before it receives cash?

q. What is the ratio we generally use to estimate a firm’s ability to meet its annual interest payments? And calculate that ratio for Dallas associates.

r. What are the fixed assets turnover ratio and the total asset turnover ratio?

s. What is the ratio of total debt to total capital?

t. What is the ratio of return on common equity?

u. Assume between 2016 and 2017, net operating working capital has increased by $500,000, calculate Dallas & Associates free cash flow. (Hint: use this formula. FCF = [EBIT (1-T) +Depreciation & Amortization] – [Capital Expenditures + Change on Net Operating Working Capital])

v. Now after you present your analysis on the meeting, the CEO would like to see higher sales and a forecasted net income of $10.8 million. Assume that operating costs (excluding depreciation and amortization) are still one third of sales and that depreciation and amortization and interest expenses will increase by 10%. The tax rate which is 40%, will remain the same. What level of sales would generate $10.8 million in net income?

THANK YOU!

Solutions

Expert Solution

Assets Liabilities and shareholders' equity
Cash and cash equivalents 1500000 Accounts Payable 400000
Accounts receivables 400000 Accruals 600000
Inventory 600000 Total Current liabilities 1000000
Total Current Assets 2500000
Notes Payable 500000
Long-term debt 2500000
Total iabilities 4000000
Plant and Equipment (net) 5000000
Common Equity 3500000
Total Assets 7500000 Total Liabilities and shraeholders' equity 7500000

b. $7,500000

c. $2,500,000

d. $1,000,000

e. $600,000

f. $4,000,000

g. $3,000,000

h. $6,500,000

i. $1,500,000 (Current assets - current liabilities)

j. $1,500,000 (In the question all current assets and liabilities are operating items)

k. $1,000,000 ($3,500,000 - $2,500,000)

l. There will be no change in the total current assets as the form of the asset changes from cash to marketeable securities.

m.

n. Operating margin = $9.4m ( EBIT)

o. Operating marin = 62.67% ($9.4 / $15)

Profit Margin = 36.00% ($5.4 / $15)

p. 9.73 days . -- Working is given below.

Receivables turnover 37.5
(Receivables / Sales)
Average collection period           9.73 days
(365 / receivables turnover)

q. times interest earned = 23.5 times. (Working is given below.)

EBIT A 9.4
Interest Expense B 0.4
Times interest earned (A/B) 23.5 times

Related Solutions

I know it's a lot but they are all small questions related to the same case...
I know it's a lot but they are all small questions related to the same case so I didn't know how to split it into multiple questions. I would really appreciate the help, as I need a way to compare my answers. Dallas & Associates Financial Statement Preparation & Analysis You have been hired as a senior financial analyst for Dallas and Associates and you are in charge of preparing the financial statements and presenting an annual analysis at the...
I know it's a lot but they are all small questions related to the same case...
I know it's a lot but they are all small questions related to the same case so I didn't know how to split it into multiple questions. I would really appreciate the help, as I need a way to compare my answers. Dallas & Associates Financial Statement Preparation & Analysis You have been hired as a senior financial analyst for Dallas and Associates and you are in charge of preparing the financial statements and presenting an annual analysis at the...
Trying this one again too... it's a completely different question, I need to know how to...
Trying this one again too... it's a completely different question, I need to know how to make the (100 ml) solution. Glacial acetic acid is 99.5% acetic acid (f.w. 60.052) by weight and has a density of 1.05g/mL. Describe the operations needed to prepare exactly 100 ml of 0.100M pH 5.000 buffer, using the dry salt sodium acetate and the liquid glacial acetic acid.
• Explain in details the P-V and T-V diagrams (thermodynamcis) I need their explannation and their...
• Explain in details the P-V and T-V diagrams (thermodynamcis) I need their explannation and their clear meaning if it is hand-written, keep it clear please
This is a critical thinking question. I know the answers. My question is in bold below...
This is a critical thinking question. I know the answers. My question is in bold below the textbook question. Ch 13, #57PE - A deep-sea diver should breath a gas mixture that has rthe same oxygen partial pressure as at sea level, where dry air contains 20.9% oxygen and has a total pressure of 1.01x105 N/m2. When developing a strategy for solving this problem, how can the given information and the principles that govern this context lead me to what...
I ONLY need answers from Question 5 to Question 10 Thank you! After ten years on...
I ONLY need answers from Question 5 to Question 10 Thank you! After ten years on the job, Drew is trying to decide whether to go back to school and get a masters degree. He performs a cost-benefit analysis to determine whether the cost of attending school will be covered by the increase in salary he will received after he attains his degree. He does research and compiles data on annual salaries in his industry, health care, along with the...
I need answers for question 3 and 4. I believe I'm correct with question 1 and...
I need answers for question 3 and 4. I believe I'm correct with question 1 and 2 but not sure which could make question 3 and 4 incorrect. calculate descriptive statistics for the variable (Coin) where each of the thirty-five students in the sample flipped a coin 10 times. Round your answers to three decimal places and type the mean and the standard deviation in the grey area below. Coin 7 6 4 6 4 6 4 6 4 4...
this is a question for marketing class, i need to know out of all of the...
this is a question for marketing class, i need to know out of all of the 2020 year Toyota vehicles, which trims have navigation for which models? for ex the Toyota Tundra Platinum and higher has navigation, and etc.
What do I need to know about this question?"Know what the Prisoner’s Dilemma is and...
Know what the Prisoner’s Dilemma is and be able to explain how it relates to collective action problems in world politics. Also, you should be able to evaluate the Kantian peace argument.
The class is Psychology - 223 but it's more a Statistics question... 1.I need to describe...
The class is Psychology - 223 but it's more a Statistics question... 1.I need to describe the hypothesis associated with my research scenario. 2. I need to state my understanding of what each hypotheses mean. 3. I need to identify the null and alternative hypothesis using appropriate statistical symbols and language based on what is being compared in my research scenario. And can someone please explain to me how to use that immage up load thing that is asking for...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT