1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Lisa [10]
3 years ago
15

You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters (where all of the

firm's records are kept) has been destroyed by fire. So, your first job will be to recreate the firm's cash flow statement for the year just ended. The firm had $100,000 in the bank at the end of the prior year, and its working capital accounts except cash remained constant during the year. It earned $5 million in net income during the year but paid $750,000 in dividends to common shareholders. Throughout the year, the firm purchased $5.4 million of machinery that was needed for a new project. You have just spoken to the firm's accountants and learned that annual depreciation expense for the year is $450,000; however, the purchase price for the machinery represents additions to property, plant, and equipment before depreciation. Finally, you have determined that the only financing done by the firm was to issue long-term debt of $1 million at a 5% interest rate. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below.
What was the firm's end-of-year cash balance? Recreate the firm's cash flow statement to arrive at your answer. Write out your answer completely. For example, 5 million should be entered as 5,000,000. Round your answer to the nearest dollar, if necessary.
Business
1 answer:
Alekssandra [29.7K]3 years ago
8 0

Answer:

$400,000

Explanation:

Given the following :

Beginning Cash balance = $100,000

Net income during the year = $5,000,000

Dividend to common shareholders = $750,000

Purchase of machinery = $5,400,000

Depreciation expense = $450,000

Long term debt = $1,000,000

Rate = 5%

STATEMENT OF CASH FLOW:

Cashflow from operating activities :

Net income ___________5,000,000

Add: Depreciation exp. ___450,000

Net cash: ____________________5,450,000

Cashflow from. Investing Activities :

Purchase of machinery __(5,400,000)

Net cash: ____________________(5,400,000)

Cashflow from financing activities:

Payment of Dividend __(750,000)

Long term debt ______1,000,000

Net cash from financing __________250,000

Net increase in cash: ____________300,000

Beginning cash balance __________100,000

Year end Cash balance __________ 400,000

You might be interested in
The company estimates that it can issue debt at a rate of rd = 9%, and its tax rate is 40%. It can issue preferred stock that pa
klio [65]

Answer:

a)

Cost of debt (after tax) = 5.4%

Cost of preferred stock (r_p)  = 10.53%

Cost of common stock (r_e) = 16.18%

b)

WACC = 14%

c)

project 1 and project 2

Explanation:

Given that:

Debt rate (r_d) = 9% = 0.09

Tax rate (T) = 40% = 0.4

Dividend per share (D_p) = $6

Price per share (P_p) = $57

Common stock price (P_0)= $39

Expected dividend (D_1) = $4.75

Growth rate (g) = 4% = 0.04

The target capital structure consists of 75% common stock (w_e), 15% debt (w_d), and 10% preferred stock  (w_p)

a)

Cost of debt (after tax) =`r_d(1-T)= 0.09(1-0.4)=0.09*0.6=0.054

Cost of debt (after tax) = 5.4%

Cost of preferred stock (r_p) = \frac{D_p}{P_P}=\frac{6}{57}=0.1053 = 10.53%

r_p = 10.53%

Cost of common stock (r_e) = \frac{D_1}{P_0} +g=\frac{4.75}{39} +0.04=0.1618

r_e = 16.18%

b)

WACC=w_dr_d(1-T)+w_er_e+w_pr_p\\WACC=0.15*0.09(1-0.4)+0.75*0.1618+0.1*0.1053=0.14

WACC = 14%

c) Only projects with expected returns that exceed WACC will be accepted. Therefore only project 1 and project 2 would be accepted

4 0
2 years ago
When budgeting for your immediate needs, you should divide them into what two categories of expenses
Usimov [2.4K]
Fixed expenses and flexible expenses or Discretionary expenses
5 0
3 years ago
Read 2 more answers
Catherine decided to have lunch at tom's, one of the most popular restaurants in town. she ordered soup before her main course a
Ostrovityanka [42]
<span>Catherine will lose the case since she did not sustain any damages. However, there is a slim (and very unlikely) chance that T</span>om's will might agree to settle if Catherine claims damages in terms of emotional trauma.
5 0
3 years ago
Carver Corporation produces a product which sells for $40. Variable manufacturing costs are $18 per unit. Fixed manufacturing co
son4ous [18]

Answer:

$16

Explanation:

The computation of contribution margin per unit is shown below:-

For computing the contribution margin per unit first we need to find out the selling commission which is shown below:-

Selling commission = Sold product × Selling commission percentage

= $40 × 15%

= $6

Now, Contribution margin = Sales - Variable costs

=$40 - ($18 + $6)

= $40 - $24

=$16

7 0
2 years ago
Lowes has found that women prefer to do larger home-improvement projects with a man, whether a boyfriend, husband, or neighbor.
Romashka [77]
Lowes offers co-ed store clinics for projects like sink installation in this situstion according is the sociocultural segment of the general environment. The sociocultural segmdn involves the values and beliefs in a society.
7 0
2 years ago
Other questions:
  • Who conducts the certifcation election​
    6·1 answer
  • ABC Co. expects to sell 2,200 units, give or take 10 percent. The expected variable cost per unit is $8.43 and the expected fixe
    11·1 answer
  • Targaryen Corporation has a target capital structure of 75 percent common stock, 10 percent preferred stock, and 15 percent debt
    10·1 answer
  • Suppose you are going to receive $13,200 per year for five years. The appropriate interest rate is 8.1 percent.
    13·1 answer
  • Pretzelmania, Inc., issues 5%, 20-year bonds with a face amount of $50,000 for $44,221 on January 1, 2021. The market interest r
    14·1 answer
  • Select the correct statement from the following, assuming Camacho Company had a favorable direct materials price variance of $2,
    8·1 answer
  • Eton Corporation purchased land in 1998 for $190,000. In 2018, it purchased a nearly identical parcel of land for $430,000. In i
    5·1 answer
  • PLEASE HELP ASAP!
    11·1 answer
  • Rhett made his annual gambling trip to uwin casino. on this trip rhett won $250 at the slots and $1,200 at poker. also this year
    13·1 answer
  • Last year the Baldwin company increased their equity. In 2020 their equity was $49,131. Last year (2021) it increased to $54,834
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!