Ask question

Ask question

All categories

3 years ago

12

Mike's Motors Corp. manufactures motors for dirt bikes. The company requires a minimum $30,000 cash balance at each month-end. I

f necessary, the company borrows to meet this requirement, at a cost of 3% interest per month (paid at the end of each month). Any cash balance above $30,000 at month-end is used to repay loans. The cash balance on July 1 is $41,000, and the company has no outstanding loans at that time. Forecasted cash receipts and forecasted cash payments (other than for loan activity) are as follows.
Cash Receipts Cash Payments
July $92,000 $120,000
August 118,000 106,900
September 157,000 134,400

Required:
Prepare a cash budget for July, August, and September.

1 answer:

Lapatulllka [165]3 years ago

6 0

Answer:

Mike's Motors Corp.

Cash Budget

July August September

Beginning balance $41,000 $30,000 $30,000

Cash receipts 92,000 118,000 157,000

Total cash available $133,000 $148,000 $187,000

Cash payments 120,000 106,900 134,400

Interest/Loan repayment 11,100 6,602

Cash balance 13,000 30,000 45,998

Cash to borrow 17,000 0 0

Minimum cash balance $30,000 $30,000 $30,000

Explanation:

a) Data and Calculations:

Minimum cash balance = $30,000

Interest rate on borrowings = 3% per month

Beginning cash balance = $41,000

Cash Budget

July August September

Beginning balance $41,000 $30,000 $30,000

Cash receipts 92,000 118,000 157,000

Total cash available $133,000 $148,000 $187,000

Cash payments 120,000 106,900 134,400

Interest/Loan repayment 11,100 6,602

Cash balance 13,000 30,000 45,998

Cash to borrow 17,000 0 0

Minimum cash balance 30,000 30,000 30,000

Loan repayment:

In August:

Interest is paid = $510 ($17,000 * 3%)

Loan is repaid = 10,590

Total paid = $11,100

Balance of loan unpaid = $6,410 ($17,000 - 10,590)

In September:

Interest on loan = $192 ($6,410 * 3%)

Loan repaid = 6,602 ($6,410 + 192)

You might be interested in

Today a shoe store took 20% off the price of a pair of shoes, and for the next 3 days, it will take 20% off the previous day's p

vesna_86 [32]

If the price of the shoe yesterday was $200 and on this day 20 percent has been taken thus it will have $160. In the next 3 days if another 20 percent will be taken out from the previous $160 then the final answer is $128.

8 0

3 years ago

Read 2 more answers

A mutual fund that attempts to hold quantities of shares in proportion to their representation in the market is called a _______

aniked [119]

Answer:

Index.

Explanation:

Mutual funds are a type of investment that takes money from many investors and uses it to make investments based on a stated investment objective.

An index fund is a type of mutual fund with a portfolio constructed to match or track the components of the market index. These are mutual funds whose holdings aim to track the performance of a specific stock market index. Index funds also track bonds, real estate, and other types of assets. These funds are lower cost than other types of funds.

5 0

3 years ago

A manufacturer of handcrafted wine racks has determined that the cost to produce x units per month is given by upper c equals 0.

Fantom [35]

Answer:

The cost per month is increasing at a rate $365.

Explanation:

Differentiation Formula

$\frac{d}{dx}(x^n)= nx^{n-1}$
$\frac{d}{dx}(a)=0$ [ where a is a constant]
$\frac{d}{dx}(ax^n)=a \frac{d}{dx}(x^n)= anx^{n-1}$

Given that,

A manufacturer of handcrafted wine racks has determined that the cost to produce x units per month is given by

$c=0.2x^2+10,000$ .

Again given that,

the rate of changing production is 13 unit per month

i.e $\frac{dx}{dt}=13$

To find the cost per month, we need to find out the value $\frac{dc}{dt}$ when production is changing at the rate 13 units per month and the production is 70 units.

$c=0.2x^2+10,000$

Differentiating with respect to t

$\frac{d}{dt}(c)=\frac{d}{dt}(0.2x^2)+\frac{d}{dx}(10,000)$

$\Rightarrow \frac{dc}{dt}=0.2\frac{d}{dt}(x^2)+\frac{d}{dx}(10,000)$

$\Rightarrow \frac{dc}{dt}=0.2\times 2x^{2-1}\frac{dx}{dt}+0$

$\Rightarrow \frac{dc}{dt}=0.4x\frac{dx}{dt}$

Plugging $\frac{dx}{dt}=13$

$\Rightarrow \frac{dc}{dt}=0.4x\times 13$

$\Rightarrow \frac{dc}{dt}=5.2x$

$\frac{dc}{dt}|_{x=70}=5.2\times 70$ [ plugging x=70]

=364

[ The unit of c is not given. Assume that the unit of c is dollar.]

The cost per month is increasing at a rate $365.

4 0

3 years ago

Jones, a farmer, found an odd-looking stone in his fields. he went to smith, the town jeweler, and asked him what he thought it

Tresset [83]

Even though there was a miscommunication in the sale, Jones did not know that the stone was a diamond before selling it and Smith can easily say he did not know it was either. If Jones had taken the stone and received other opinions on it, he may have gotten more money but because he sold the stone, there is nothing he can take action on Smith for.

5 0

3 years ago

Consider the following transactions for Huskies Insurance Company: Equipment costing $30,000 is purchased at the beginning of th

Reika [66]

Answer:

a. Dr Depreciation expense $5,000

Cr Accumulated depreciation $5,000

b. Dr Interest receivable 750

Cr Interest revenue 750

c. Dr Unearned revenue 2,000

Cr Service revenue 2,000

Explanation:

Preparation to record the necessary adjusting entry for Huskies Insurance at its year-end of December 31.

a. Dr Depreciation expense $5,000

Cr Accumulated depreciation $5,000

(Being to adjust for Depreciation of Equipment)

b. Dr Interest receivable 750

Cr Interest revenue 750

(30,000*5%*6/12)

(Being to adjust for accrued interest)

c. Dr Unearned revenue 2,000

Cr Service revenue 2,000

(8,000*3/12)

(Being to adjust for accrued rent revenue)

6 0

3 years ago