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
Iteru [2.4K]
2 years ago
9

Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows:

Business
1 answer:
slavikrds [6]2 years ago
5 0

Answer:

Wildcat, Inc.

WILDCAT, INC. Cash Budget (in millions)

                                                  Q1           Q2          Q3          Q4

Beginning cash balance         $78.00    $115.90   $48.45   $83.40

Net cash inflow                         37.90      -67.45     34.95      71.05

Ending cash balance             $115.90    $48.45    $83.40 $154.45

Minimum cash balance          -40.00     -40.00     -40.00   -40.00

Cumulative surplus (deficit)  $75.90      $8.45    $43.40  $114.45

Explanation:

a) Data and Calculations:

                                 Q1      Q2      Q3      Q4     Q1

Sales (in millions) $165   $185  $205  $235   $180

Accounts receivable at beginning of the year = $71 million

Collection period = 45 days = 50% in each quarter and 50% in the next

Purchases for the quarter = 45% of next quarter's forecast sales

Payment period = 36 days

Wages, taxes, etc. = 20% of sales

                                      Q1          Q2        Q3        Q4         Q1

Sales (in millions)        $165       $185    $205       $235     $180

Cash collections:

50% quarter of sales             82.50    92.50    102.50     117.50

50% next quarter                   71.00     82.50    92.50    102.50

Total cash collections          153.50    175.00   195.00   220.00

Purchases                              83.25     92.25  105.75   81.00

Cash Payments:

80% month of purchase      66.60     73.80   84.60   64.80

20% following purchase                     16.65    18.45     21.15

Total purchases payments 66.60     90.45  103.05  85.95

Wages, taxe, etc.                 33           37          41        47

Interest and dividends        16            16          16        16

Capital outlay                                     99

Total cash disbursements 115.60   242.45   160.05  148.95

Net cash inflow                   37.90   -67.45      34.95    71.05

Cash, beginning = $78 million

Desired minimum balance = $40 million

You might be interested in
Peng Company is considering an investment expected to generate an average net income after taxes of $3,300 for three years.
nikdorinn [45]

Answer:

3482.12

Explanation:

Net present value is the present value of after-tax cash flows from an investment less the amount invested.  

NPV can be calculated using a financial calculator  

Cash flow = net income + depreciation = 16,200 + 3300 = 35,700

($56,100 - $7500) / 3 = 16,200

Cash flow in year 0 = 56,100

cash flow in year 1 and 2 = 35700

cash flow in year 3 = 35,700 + 7500

i = 5%

NPV =

3 0
3 years ago
Joe Chin bought a house for $180,000. He made a 20% down payment. Joe secured a loan for the balance of the purchase price at 6.
Ivan

Answer:

  910.18

Explanation:

After Chin's down payment the amount borrowed is ...

  (1 - 20%)($180,000) = 0.80·$180,000 = $144,000

The amount of the payment is given by the amortization formula ...

  A = P(r/n)/(1 -(1 +r/n)^(-nt))

for P borrowed at rate r for t years, compounded n times per year.

  A = 144000(0.065/12)/(1 -(1 +.065/12)^(-12·30)) = 910.18

The monthly loan payments will be 910.18.

6 0
3 years ago
A mortgage requires you to pay $70,000 at the end of each of the next eight years. The interest rate is 8%.
bazaltina [42]

Answer:

PV $402,264.7261

balance of the mortage

1-y from now   $364,445.9041

2-y from now   $323,601.5765

3-y from now  $279,489.7026

4-y from now  $231,848.8788

5-y from now $180,396.7891

6-y from now   $124,828.5322

7-y from now   $64,814.8148

Explanation:

We sovle for the PV of the annuity of 70,00 during 8 years discounted at 8%

C \times \frac{1-(1+r)^{-time} }{rate} = PV\\

C 70,000.00

time 8

rate 0.08

70000 \times \frac{1-(1+0.08)^{-8} }{0.08} = PV\\

PV $402,264.7261

To know the value of the outstanding dbet we can repeat this formula changing the values for time

t = 7   $364,445.9041

t = 6   $323,601.5765

t = 5   $279,489.7026

t = 4   $231,848.8788

t = 3   $180,396.7891

t = 2   $124,828.5322

t = 1   $64,814.8148

8 0
2 years ago
A portfolio is invested 20 percent in Stock G, 60 percent in Stock J, and 20 percent in Stock K. The expected returns on these s
disa [49]

Answer:

The portfolio's expected return is 15%

Explanation:

The expected return of a portfolio is the sum of the weight of each asset times the expected return of each asset.

So, the expected return of the portfolio is:

E(RP) = 0.20(.09) + 0.60(.15) + 0.20(.21)

= 0.018 + 0.09 + 0.042

E(RP) = 0.15 or 15%

If we own this portfolio, we would expect to earn a return of 15 percent.

7 0
3 years ago
________ involves the study of an individual's involuntary responses to marketing stimuli, including eye movement, heart rate, s
mixer [17]

Answer:

A. Neuromarketing

Explanation:

Neuromarketing uses functional magnetic resonance imaging and brain waves to study the involuntary responses to marketing stimuli of an individual

7 0
3 years ago
Other questions:
  • Economists expect the firm to maximize __________, the laborer to accept the best __________, and the consumer to find the combi
    8·2 answers
  • ___ requires creditors to provide borrowers with a complete written account of credit terms and costs.
    7·1 answer
  • Socioeconomic market segmentation is another name for _____ segmentation.
    7·1 answer
  • The annual interest rate on a credit card is 13.99​%. If a payment of ​$400.00 is made each​ month, how many months will it take
    7·1 answer
  • A client with renal colic is scheduled for extracorporeal shock-wave lithotripsy. The night before the procedure, the client put
    9·1 answer
  • After the Container Store forecasts human resources demand and supply, the firm is likely to engage in a systematic procedure fo
    13·2 answers
  • Presented below are four statements which you are to identify as true or false. If false, explain why the statement is false.
    15·1 answer
  • Establishing a secure customer or client base is an example of how to deal with this type of risk.
    8·1 answer
  • you are considering starting a business to provide high quality bookkeeping services targeted to restaurants and other food serv
    6·1 answer
  • In kennedy's speech to rice university, find at least one example of: scope time cost quality human resources communication risk
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!