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
Las Paletas Corporation has two different bonds currently outstanding. Bond M has a face value of $20,000 and matures in 20 year
Margarita [4]

Answer:

Bond M= $21,914.32.

Bond N= $6,131.14

Explanation:The price of any bond (or financial instrument) is the PV of the future cash flows. Even though Bond M makes different coupons payments,to find the price of the bond,we just find PV for the cash flows

5 0
3 years ago
Below are the transactions for Ute Sewing Shop for March, the first month of operations.
balandron [24]

Answer:

Explanation:

March 1

Cash  1700

    Share Capital 1700

To record the issuance of shares

March 3

Equipment 1400

  Cash           1400

To record the purchase of equipment on cash

March 5

Rent Expense 470

    Cash               470

To record the rent expense

March 7

No entry neither cash nor serves are provided.

March 12

Purchase 117

  Cash           117

To record the purchases

March 15

Cash 670

 Income 670

To record the services Income.

March 19

Advance 570

     Payable   570

To record the advance cash receipt for services not yet provided thus advance is our liability.

March 25

Payable 228    570/25*10

   Income    228

To record the services income against advance given.

March 30

Utilities Expense   82

    Cash                      82

To record the monthly utilities expense

March 31

Dividend Pay  85

       Cash              85  

To record the payment of dividend.

2)

                                <u>Share Capital Account</u>

                                                 Opening =    0

                                                   Cash          1700

          <u>Closing=1700</u>                 <u>                            </u>

 

                                     <u>Cash  Account</u>

Opening = 0

share capital   1700                              Equipment          1400

                                                               Rent                   470

                                                                Purchase           117

Income             670

Adv. Pay           570

                                                                  Utilities             82

                                                                   Dividend          85

                                                                   <u>Closing balance- 786</u>    

     

                                       <u>Equipment</u>

Opening = 0

Cash           1400

                                                             <u>Closing-1400</u>

                                       <u>Rent Expense</u>

Opening = 0

Cash           470

                                                             <u>Closing-470</u>

                                       <u>Purchase Expense</u>

Opening = 0

Cash           117

                                                             <u>Closing-117</u>

                                <u>Income Account</u>

                                                 Opening =    0

                                                   Cash          670

                                                    Payable     228

      <u>Closing- 898</u>                                           <u>                            </u>

                                <u>Payable Account</u>

                                                             Opening =    0

                                                             Cash          570

Income 282

<u>Closing-342</u>                                           <u>                            </u>

                                       <u>Utilities Expense</u>

Opening = 0

Cash           82

                                                             <u>Closing-82</u>

                                   <u>Dividend</u>

Opening = 0

Cash           85

                                                             <u>Closing-85</u>

3)                     Trail Balance

     Head Of Account                           Debit                    Credir

Cash                                   786  

Share Capital                                           1700

Equipment                           1400  

Rent Expense                                                   470  

Purchases                            117  

Income                                                           898

Payable                             342

Utilities                                     82  

Dividend                                            85  

Total                                   2940                 2940

7 0
3 years ago
In accounting, currency, coins, checks, money orders, and funds on deposit in a bank are recorded in?
Dafna1 [17]

In accounting, currency, coins, checks, money orders, and funds on deposit in a bank are recorded in cash.

<h3>What is cash in a bank in accounting?</h3>
  • Cash in Bank refers to the current balance in checking or savings accounts or other accounts of a similar nature held in the name of the company or business requesting the certificate. Do not include amounts from personal bank accounts or retirement accounts.
  • Every month, the bank will normally send the account holder an official bank statement that lists all of the transactions that occurred on the account that month. Account information can be found on bank statements, including account numbers and a thorough list of deposits and withdrawals.
  • There are three different forms of accounting transactions based on the exchange of money: cash transactions, non-cash transactions, and credit transactions.

In accounting, currency, coins, checks, money orders, and funds on deposit in a bank are recorded in cash.

To learn more about bank accounts, refer to:

brainly.com/question/24179665

#SPJ4

8 0
1 year ago
Conventional wisdom says one should measure a manager's investment performance over an entire market cycle. What arguments suppo
White raven [17]

Answer:

In every form of analysis, it is always safer to take a macro or holistic view of the situation. This is true for the investment performance of a manager. One investment decision that went right does not suffice to classify an investment portfolio manager as proficient, neither is one that went south enough to tag him deficient.

The forecasting ability of managers, on the balance of probability, will vary for different cases, with a helicopter view of providing a more accurate measure of their performance.

However, if it was possible to analyse the market for volatility and adjust our forecasts it becomes unnecessary to look at and analyse all the information from a 12-month cycle before coming to terms about the performance of the manager.

Cheers!

4 0
3 years ago
A company's environmental sustainability strategy consists of its deliberate actions to:A. shelter the environmental impacts fro
Rus_ich [418]

Answer:

Operate the business in a manner that promotes the longevity of sustainability effects.

Explanation:

A company's environmental sustainability strategy comprises of different actions that are carried out to maintain an effective environmental management system inorder to ensure that the company increases it's sales and maximises profit. This type of strategy helps to create a long term value for an organization. Examples of practices that companies carry out to ensure a sustainable environment include:

- Recruiting and training employees on different ways to maintain a sustainable environment.

- Creating an effective recycling program.

- Usage of environmental friendly equipments in the organisation.

5 0
4 years ago
Other questions:
  • Why is important to know your strengths and weaknesses? Do you have more strengths or weaknesses? What can you do to help improv
    9·1 answer
  • Any marketing method that directly links manufacturers or intermediaries with the ultimate consumer could be classified as:
    12·1 answer
  • Tracy transfers property with a value of $60,000 and adjusted basis of $50,000 to form Riley Corp. solely in exchange for all 10
    15·1 answer
  • A favorable direct materials quantity variance indicates which of the following?A) The actual cost of direct materials was less
    8·1 answer
  • Swifty Corporation reported net sales of $690000, $730000, and $828000 in the years 2016, 2017, and 2018, respectively. If 2016
    6·1 answer
  • What is accounting theory​
    9·1 answer
  • The American Civil Liberties Union was heavily funded by the Republican Party and Wall Street businessmen in the hopes of promot
    10·1 answer
  • Suppose that Greece and Switzerland both produce beer and olives. Greece's opportunity cost of producing a crate of olives is 5
    9·1 answer
  • A company's balance sheet shows: Cash $36,000, Accounts receivable $23,000, Office equipment $57,000, and Accounts payable $24,0
    5·1 answer
  • Financial statement data for years ending December 31 for tango company follow
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!