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
NARA [144]
3 years ago
5

Schedule of cash payments for a service company Horizon Financial Inc. was organized on February 28. Projected selling and admin

istrative expenses for each of the first three months of operations are as follows:
March $160,800
April 152,800
May 139,000
Depreciation, insurance, and property taxes represent $35,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taxes for the year will be paid in June. 73% of the remainder of the expenses are expected to be paid in the month in which they are incurred, with the balance to be paid in the following month.
Prepare a schedule of cash payments for selling and administrative expenses for March, April, and May.
Business
1 answer:
Ksenya-84 [330]3 years ago
5 0

Answer:

Total Cash Payments are as follows:

For March = $91,834

For April = $119,960

For May = $107,726

Explanation:

Note: See the attached Excel file for the schedule of cash payments

The expenses paid in each month are estimated as follows:

a. March Expenses

Paid in March = (Total projected selling and administrative expenses for March - Depreciation, insurance, and property taxes for March) * Percentage of reminder paid = ($160,800 - $35,000) * 73% = $91,834

Paid in April = (Total projected selling and administrative expenses for March - Depreciation, insurance, and property taxes for March) * Percentage of balance paid = ($160,800 - $35,000) * (100% - 73%) = $33,966

b. April Expenses

Paid in April = (Total projected selling and administrative expenses for April - Depreciation, insurance, and property taxes for April) * Percentage of reminder paid = ($152,800 - $35,000) * 73% = $85,994

Paid in May = (Total projected selling and administrative expenses for April - Depreciation, insurance, and property taxes for April) * Percentage of balance paid = ($152,800 - $35,000) * (100% - 73%) = $31,806

c. May Expenses

Paid in May = (Total projected selling and administrative expenses for May - Depreciation, insurance, and property taxes for May) * Percentage of reminder paid = ($139,000 - $35,000) * 73% = $75,920

Download xlsx
You might be interested in
Peach Company uses a weighted-average process-costing system. Company records disclosed that the firm completed 40,000 units dur
Advocard [28]

Answer:

D. $28.50

Explanation:

Peach Equivalent-unit cost = Total Cost / Units

Peach Equivalent-unit cost = ($966000 + $231000) / (40000 units + (10000 units*20% completion))

Peach Equivalent-unit cost = $1197000 / (40000 units + 2000 units)

Peach Equivalent-unit cost = $1197000 / 42000 units

Peach Equivalent-unit cost = $28.50

5 0
3 years ago
Jim Walton perform services on credit for $2450 a debit for this transaction should be recorded to?
ki77a [65]
A) accounts receivable 

Hope this helped!
5 0
3 years ago
PLEASE LEAVE A COMMENT EVEN IF THERE ARE TWO ANSWERS! Hi, I am picking a name for my coffee shop, I was thinking CoffeeCake beca
sveta [45]
...coffecakes thats a cute name

3 0
3 years ago
Read 2 more answers
Should the United States acced to the United Nations Law of the Seas without reservations?
grin007 [14]

I think that the answer to this question should be based upon your opinion sorry if you were expecting the actual answer


5 0
3 years ago
Suppose that the S&P 500, with a beta of 1.0, has an expected return of 13% and T-bills provide a risk-free return of 4%. a.
Aleksandr [31]

Answer:

a. The answers are as follows:

(i) Expected of Return of Portfolio = 4%; and Beta of Portfolio = 0

(ii) Expected of Return of Portfolio = 6.25%; and Beta of Portfolio = 0.25

(iii) Expected of Return of Portfolio = 8.50%; and Beta of Portfolio = 0.50

(iv) Expected of Return of Portfolio = 10.75%; and Beta of Portfolio = 0.75

(v) Expected of Return of Portfolio = 13%; and Beta of Portfolio = 1.0

b. Change in expected return = 9% increase

Explanation:

Note: This question is not complete as part b of it is omitted. The complete question is therefore provided before answering the question as follows:

Suppose that the S&P 500, with a beta of 1.0, has an expected return of 13% and T-bills provide a risk-free return of 4%.

a. What would be the expected return and beta of portfolios constructed from these two assets with weights in the S&P 500 of (i) 0; (ii) 0.25; (iii) 0.50; (iv) 0.75; (v) 1.0

b. How does expected return vary with beta? (Do not round intermediate calculations.)

The explanation to the answers are now provided as follows:

a. What would be the expected return and beta of portfolios constructed from these two assets with weights in the S&P 500 of (i) 0; (ii) 0.25; (iii) 0.50; (iv) 0.75; (v) 1.0

To calculate these, we use the following formula:

Expected of Return of Portfolio = (WS&P * RS&P) + (WT * RT) ………… (1)

Beta of Portfolio = (WS&P * BS&P) + (WT * BT) ………………..………………. (2)

Where;

WS&P = Weight of S&P = (1) – (1v)

RS&P = Return of S&P = 13%, or 0.13

WT = Weight of T-bills = 1 – WS&P

RT = Return of T-bills = 4%, or 0.04

BS&P = 1.0

BT = 0

After substituting the values into equation (1) & (2), we therefore have:

(i) Expected return and beta of portfolios with weights in the S&P 500 of 0 (i.e. WS&P = 0)

Using equation (1), we have:

Expected of Return of Portfolio = (0 * 0.13) + ((1 - 0) * 0.04) = 0.04, or 4%

Using equation (2), we have:

Beta of Portfolio = (0 * 1.0) + ((1 - 0) * 0) = 0

(ii) Expected return and beta of portfolios with weights in the S&P 500 of 0.25 (i.e. WS&P = 0.25)

Using equation (1), we have:

Expected of Return of Portfolio = (0.25 * 0.13) + ((1 - 0.25) * 0.04) = 0.0625, or 6.25%

Using equation (2), we have:

Beta of Portfolio = (0.25 * 1.0) + ((1 - 0.25) * 0) = 0.25

(iii) Expected return and beta of portfolios with weights in the S&P 500 of 0.50 (i.e. WS&P = 0.50)

Using equation (1), we have:

Expected of Return of Portfolio = (0.50 * 0.13) + ((1 - 0.50) * 0.04) = 0.0850, or 8.50%

Using equation (2), we have:

Beta of Portfolio = (0.50 * 1.0) + ((1 - 0.50) * 0) = 0.50

(iv) Expected return and beta of portfolios with weights in the S&P 500 of 0.75 (i.e. WS&P = 0.75)

Using equation (1), we have:

Expected of Return of Portfolio = (0.75 * 0.13) + ((1 - 0.75) * 0.04) = 0.1075, or 10.75%

Using equation (2), we have:

Beta of Portfolio = (0.75 * 1.0) + ((1 - 0.75) * 0) = 0.75

(v) Expected return and beta of portfolios with weights in the S&P 500 of 1.0 (i.e. WS&P = 1.0)

Using equation (1), we have:

Expected of Return of Portfolio = (1.0 * 0.13) + ((1 – 1.0) * 0.04) = 0.13, or 13%

Using equation (2), we have:

Beta of Portfolio = (1.0 * 1.0) + (1 – 1.0) * 0) = 1.0

b. How does expected return vary with beta? (Do not round intermediate calculations.)

There expected return will increase by the percentage of the difference between Expected Return and Risk free rate. That is;

Change in expected return = Expected Return - Risk free rate = 13% - 4% = 9% increase

4 0
3 years ago
Other questions:
  • Opera Corp. uses dollar-value LIFO method of computing its inventory cost. Data for the past three years is as follows:
    14·1 answer
  • ​michelle's business produces ceramic cups using​ labor, clay, and a kiln. she produces cups using a fixed proportion of labor a
    9·1 answer
  • By combining their resources and developing shared goals, procter & gamble and walmart were able to increase the value to th
    6·1 answer
  • Jeff has the opportunity to receive​ lump-sum payments either now or in the future. Which of the following opportunities is the​
    14·1 answer
  • Anderson's Furniture Outlet has an unlevered cost of capital of 8%, a tax rate of 35%, and expected earnings before interest and
    12·1 answer
  • A large, profitable commercial airline company flies 737 type aircraft each with a max seating capacity of 132 passengers. compa
    6·1 answer
  • Jill’s Dress Shop had a beginning balance in its inventory account of $40,000. During the accounting period, Jill’s purchased $7
    8·1 answer
  • Bonita Corporation has outstanding 9,100 shares of $100 par value, 6% preferred stock and 60,500 shares of $10 par value common
    15·1 answer
  • Grants Corporation prepared the following two income statements (simplified for illustrative purposes):
    13·1 answer
  • What segment of the foodservice industry is characterized by limited menus, fast service, and modest prices?
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!