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
telo118 [61]
3 years ago
5

Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash p

ayments for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash payments January $ 518,000 $ 461,500 February 403,000 346,500 March 467,000 523,000 According to a credit agreement with its bank, Kayak requires a minimum cash balance of $50,000 at each month-end. In return, the bank has agreed that the company can borrow up to $150,000 at a monthly interest rate of 1%, paid on the last day of each month. The interest is computed based on the beginning balance of the loan for the month. The company repays loan principal with any cash in excess of $50,000 on the last day of each month. The company has a cash balance of $50,000 and a loan balance of $100,000 at January 1. Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.)
Business
1 answer:
andrew11 [14]3 years ago
7 0

Answer:

a. Ending Cash Balance:

January = 50,000

February = 61,555

March = 50,000

b. Loan Balance End of Month:

January = 44,500

February = $0  

March = $44,445

Explanation:

Note: The merged data given in the question are sorted before answering the question as follows:

                            Cash Receipts                  Cash payments

January                    $ 518,000                             $ 461,500

February                     403,000                               346,500

March                          467,000                               523,000

Explanation of the answer is now given as follows:

Note: See the attached excel file for the cash budget.

In the attached excel file, the following calculations are made:

January loan repayment = January Preliminary cash balance - Minimum required cash balance = $105,500 - $50,000 = $55,500

March Additional loan = Minimum required cash balance - March Preliminary cash balance = $50,000 - $5,555 = $44,445

From the attached excel file, we have:

a. Ending Cash Balance:

January = 50,000

February = 61,555

March = 50,000

b. Loan Balance End of Month:

January = 44,500

February = $0  

March = $44,445

Download xlsx
You might be interested in
The cash records of Crane Company show the following. For July:
ad-work [718]

Answer:

A. $3,560

B. $3,430

C. $4,120

D. $3,730

Explanation:

A. Calculation for the deposits in transit at July 31

July 1 Deposit in transit=$18,550 - ($15,720 - $730)

July 1 Deposit in transit=$18,550-$14,990

July 1 Deposit in transit= $3,560

Therefore ​the deposits in transit at July 31 were $3,560

B. Calculation for the outstanding checks at July 31

July 31 Outstanding checks=$18,540 - ($16,020 - $910)

July 31 Outstanding checks=$18,540-$15,110

July 31 Outstanding checks= $3,430

Therefore the outstanding checks at July 31 were $3,430

C. Calculation for the deposits in transit at August 31

August 31 Deposits in transit=$27,280 - $26,010 + $2,850

August 31 Deposits in transit= $4,120

Therefore the deposits in transit at August 31 were $4,120

D. Calculation for the outstanding checks at August 31

August 31 Outstanding checks=$24,460 - $23,110 + $2,380

August 31 Outstanding checks= $3,730

Therefore the outstanding checks at August 31 were $3,730

6 0
3 years ago
What topic should not be discussed in a salon (Cosmetology) ​
sweet [91]

Answer:

What peoples insides look like.

Explanation:

I can list a few more.

but i don't think you want me too

3 0
2 years ago
Microsoft and a smaller rival often have to select from one of two competing technologies, A and B. The rival always prefers to
Nuetrik [128]

Answer: true, there is an equilibrium.

Explanation:

the above game is a pure strategy. A pure strategy occur when the game is strictly determined. the criteria used to determine the pure strategy is maxi-min and min-max. max-min means selecting the least case from all best cases and min-max means selecting the best from all least cases.

Base on the criterion, the least out of all best for max-min is 1 unit and the best out of all least cases for min-max is 1 unit. the max-min is equal to the min-max,hence it strictly determined and therefore a pure strategy.

5 0
3 years ago
Helmers Corporation manufactures a single product. Variable costing net operating income last year was $74,000 and this year was
gogolik [260]

Answer:

$46,400

Explanation:

The computation of the absorption costing net operating income last year is shown below:

= Net operating income under variable costing + Fixed overhead deferred in ending inventory - Fixed overhead released in beginning inventory

= $74,000 + $0 - $27,600

= $46,400

All other information which is given in the question is not relevant. Hence, ignored it

4 0
3 years ago
Which is a tax in which the percentage paid increases as income increases?
AleksAgata [21]
Progressive tax. Literally just reviewed this lesson in my econ class lol. 
8 0
3 years ago
Read 2 more answers
Other questions:
  • Why did the natural environment receive so much attention under new deal programs, and with what result?
    15·1 answer
  • The information provided by financial reporting pertains to A. individual business enterprises, industries, and an economy as a
    12·1 answer
  • Amber is working as a sales associate in a department store. When a few high-priced products are found missing from the store, A
    8·1 answer
  • Don Wyatt is unable to reconcile the bank balance at January 31. Don Wyatt’s reconciliation is as follows. Cash balance per bank
    11·2 answers
  • !! 30 Points !! You see a commercial for a new product. It promises you clear skin in 30 days and greater confidence. The compan
    6·2 answers
  • Channel richness is, in part, determined by the ability to facilitate rapid, two-way feedback.
    7·1 answer
  • How many people lost their jobs when the minimum wage increased from $12 to $18?
    8·2 answers
  • Banking is a general term for what?
    12·2 answers
  • a business intially sells their product to customers for $50. They find that many people are buying their product so they raise
    13·1 answer
  • Why is it important that the whole organization works toward the strategic plan? How do the departments affect each other in rea
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!