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
Travka [436]
4 years ago
5

Todd Enterprises is preparing a cash budget for the second quarter of the coming year. The following data have been forecasted:

(15 points, please label your answer in a cash budget format) ​ April ​ May Sales ………………………………………………. $150,000 ​ $157,500 Merchandise purchases …………………………… 107,000 ​ 112,400 Operating expenses: ​ ​ ​ Payroll …………………………………………. 13,600 ​ 14,280 Advertising ……………………………………. 5,400 ​ 5,700 Rent ……………………………………………. 2,500 ​ 2,500 Depreciation …………………………………… 7,500 ​ 7,500 End of April balances: ​ ​ ​ Cash ……………………………………………. 30,000 ​ ​ Bank loan payable ……………………………… 26,000 ​ ​ Additional data: (1) Sales are 40% cash and 60% credit. The collection pattern for credit sales is 50% in the month following the sale and 50% in the month thereafter. Total sales in March were $125,000. (2) Purchases are all on credit, with 40% paid in the month of purchase and 60% paid in the following month. (3) Operating expenses are paid in the month they are incurred. (4) A minimum cash balance of $25,000 is required at the end of each month. (5) Loans are used to maintain the minimum cash balance. At the end of each month, interest of 1% per month is paid on the outstanding loan balance as of the beginning of the month. Repayments are made at the end of the month if the cash balance exceeds $25,000. Prepare the company's cash budget for May. Show the ending loan balance at May 31.
Business
1 answer:
Fudgin [204]4 years ago
8 0

Answer:

The answer is attached for ready reference

Explanation:

Please note no effect for depreciation is taken as it is non cash item.

The may ending balance is having a surplus of $103,300              

Download xlsx
You might be interested in
A credit card had an Apr of 12.87% all of last year and compounded interest daily. What was the credit card's effective interest
alisha [4.7K]

Answer:

13.73%

Explanation:

Effective annual rate = (1 + APR / m ) ^m - 1

M = number of compounding = 365

(1 + \frac{0.1287}{365} )^{365} - 1

(1.000353)^{365} - 1 = 0.1373 = 13.73%

7 0
3 years ago
In many cases, it is reasonable to refer to the ________________ as the price.
Sladkaya [172]

Most time, it is reasonable to refer to the opportunity cost as the price because it entails the benefit of the foregone good or service.

<h3>What is an opportunity cost?</h3>

It refers to a value of what is rejected in order to perform the chosen alternative, that is, the value one have to give up to buy what you want in terms of other goods or services.

Therefore, it is sometimes reasonable to refer to the opportunity cost as the price because it entails the benefit of the foregone good or service.

Read more about opportunity cost

<em>brainly.com/question/1549591</em>

#SPJ1

6 0
2 years ago
The relationship between financial leverage and profitability Pelican Paper, Inc., and Timberland Forest, Inc., are rivals in th
OLEGan [10]

Answer:

Pelican Paper, Inc., and Timberland Forest, Inc.

Financial leverage and profitability Ratio Analysis

A. Computation of debt and coverage ratios:

1. debt ratio  = Total debt to Total assets x 100

Pelican = $1,000,000/$10,000,000 x 100

= 10%

Timberland =v$5,000,000/$10,000,000 x 100

= 50%

2. times interest earned ratio = EBIT/Interests

Pelican = $6,250,000/$100,000

= 62.5 times

Timberland = $6,250,000/$500,000

= 12.5 times

A discussion of their financial risk and ability to cover the costs:

Pelican Paper's financial leverage is 10% compared to Timberland's 50%, showing that debt creditors finance and lay claim to half of the company's assets.  This is very high and not attractive to potential investors and creditors.  Timberland has already hampered its ability to borrow more as it is highly leveraged.  Whereas Pelican Paper can meet its debt obligations and pay its interest expenses 62.5 times from current earnings, these pale in comparison with Timberland's 12.5 times, further jeopardizing its opportunities for more debt financing.

B. Calculation of the profitability ratios:

1. Operating profit margin  = EBIT/Sales x 100

Pelican Paper = $6,250,000/$25,000,000 x 100 = 25%

Timberland = $6,250,000/$25,000,000 x 100 = 25%

2. Net profit margin  = (EBIT less Interest)/Sales x 100

Pelican Paper = ($6,250,000 - $100,000)/$25,000,000 x 100

= $6,150,000/$25,000,000 x 100 = 24.6%

Timberland = ($6,250,000 - $500,000)/$25,000,000 x 100

= $5,750,000/$25,000,000 x 100 = 23%

3. Return on total assets  = EBIT/Total Assets x 100

Pelican Paper = $6,250,000/$10,000,000 x 100

= 62.5%

Timberland = $6,250,000/$10,000,000 x 100

= 62.5%

4. Return on common equity = Earnings available to Common Stockholders/Equity x 100

Pelican = $3,690,000/$9,000,000 x 100

= 41%

Timberland = $3,450,000/$5,000,000 x 100

= 69%

A discussion of their profitability relative to one another:

The two companies make the same level of operating profit margin at 25%, but Pelican's net profit margin of 24.6% is better than Timberland's 23%.  They show that Pelican's management has better ability to control expenses than Timberland's.

The returns on assets are similar for both companies, but Timberland performed better than Pelican Paper in terms of the return on equity.  This shows that Timberland with ROE of 69% is making larger returns for its common stockholders than Pelican because it is leveraging debts, whose interests are tax-deductible, and also using less equity in generating the returns.

C. The larger debt of Timberland has made it more profitable than Pelican Paper because the debt interests are deductible from EBIT before tax expense is computed and it reduces the tax burden for the company, thus making it to pay less tax and saving more profits for distribution to its stockholders.

However, this higher return to the investors in Timberland also comes with higher risks, as the investors are exposed to debt risks, higher pressure to satisfy debt creditors, heightened interference and oversight from creditors since they own half of the assets of the company, and an increased threat of business takeover in case of debt default.

Explanation:

a) Data:

Items                        Pelican Paper, INC    Timberland Forest, INC

Total assets              $10,000,000               $10,000,000

Total equity                  9,000,000                   5,000,000

Total Debt                     1,000,000                   5,000,000

Annual Interest                100,000                      500,000

Total Sales                 25,000,000                25,000,000

EBIT                              6,250,000                  6,250,000

Earnings available for  common

stockholders               3,690,000                   3,450,000

b) Ratio computation and analysis help companies to compare their performances and positions with competitors.  They can spot risks facing a company and even point out ways to address such business risks.

8 0
3 years ago
At December 31, 2019, Oriole Corporation had the following stock outstanding. 10% cumulative preferred stock, $100 par, 109,261
solong [7]

Answer:

The company should report the 03 EPS figures on its 2020 income statement:

EPS continuing operations = $3.64

EPS discontinued operations = $(0.54)

EPS net income = EPS continuing operations + EPS discontinued operations = $3.10

Explanation:

<u>* Calculation in EPS continuing operations:</u>

EPS continuing operations = (Net income from continuing operation - preferred dividend)/No. of common shares outstanding

in which: Net income from continuing operation = Income from continuing operations before taxes * (1- tax rate) = 24,649,800 * (1-35%) = $16,022,370

preferred dividend = $1,092,610

No. of common shares outstanding = 4,099,840

EPS continuing operations = ($16,022,370 - $1,092,610) / 4,099,840= $3.64

<u>* Calculation in EPS discontinued operations:</u>

EPS discontinued operations = Net income from discontinuing operation /No. of common shares outstanding

in which: Net income from continuing operation = Income from discontinuing operations before taxes * (1- tax rate) = (3,399,100) * (1-35%) = $(2,209,415)

No. of common shares outstanding = 4,099,840

EPS discontinued operations = (2,209,415)/ 4,099,840 = $(0.54)

5 0
4 years ago
You were asked to estimate the cost of capital for XYZ Inc. The firm is expected to have a target capital structure of 30% debt,
kap26 [50]

Answer:

8.30%

Explanation:

The weighted average cost of capital of the company is  computed using the WACC formula below:

WACC=(We*Ke)+(Wp*Kp)+(Wd*kd)

We=weight of common equity=50%

Ke=cost of retained earnings which is a proxy for the cost of equity=11.50%

Wp=weight of preferred stock=20%

Kp=cost of preferred stock=6.00%

Wd=weight of debt=30%

Kd=after-tax cost of debt=4.50%

WACC=(50%*11.50%)+(20%*6.00%)+(30%*4.50%)

WACC=8.30%

3 0
3 years ago
Other questions:
  • The purpose of the abstract of title is to :
    12·1 answer
  • Business transactions completed hannah venedict during september are follows. using transactions, record journal entries, create
    13·1 answer
  • Under _____ reserve banking, banks hold only a small portion of deposits in reserve, and they lend the rest
    11·1 answer
  • Charleston Corporation (CC) now operates as a "regular" corporation, but it is considering a switch to S Corporation status. CC
    8·1 answer
  • On July 10, Boogie Footware agrees to a contract to sell 800 pair of flapper shoes for $16,000 to Twenties, Inc. On September 1,
    7·1 answer
  • A $50 par value convertible preferred stock is convertible into 5 shares (exercise price of $10). The preferred is selling for $
    11·1 answer
  • Walter receives cash of $18,000 and land with a fair market value of $75,000 (adjusted basis of $50,000) in a current distributi
    5·1 answer
  • Do you want to buy mah flamago milk?
    15·2 answers
  • When deciding on an office layout, a business or organization has to consider all of the following except:
    5·1 answer
  • bookmark question for later what is a common axiom for information technology professionals? communicate! become an expert know
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!