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
What is the capacity of the machine in batches unfinished batch?
Oxana [17]

Complete Question:

You are considering the purchase of a new machine to help produce a new product line being introduced.  The machine is expected to have a setup time of 10 minutes per batch and a processing time of 2 minutes per part.  You plan to have batch sizes of 50 parts.  The plant operates 8 hours per day.

What is the capacity of the machine in batches per day?

Answer:

The capacity of the machine in batches = 4 batches per day.

Explanation:

a) Data and Calculations:

Set up time per batch = 10 minutes

Processing time per part = 2 minutes

Batch sizes = 50 parts

Plant operation = 8 hours per day

b) Capacity in batches per day:

Total batch time = 10 + 50 * 2 = 110 minutes

Total minutes of operation  per day = 8 * 60 = 480 minutes

Capacity in batches = 480/110 = 4.36 or approximately 4 batches

c) Each batch produces 50 parts with each part taking some 2 minutes and an additional batch setup time of 10 minutes, giving a total of 110 minutes per batch.  Since there are some 480 (8 * 60) minutes available per day, it means that the entity can only run about 4 batches (480/110) per day.  These 4 batches will consume a total of 440 minutes (110 x 4), leaving some 40 minutes as unutilized time.

4 0
3 years ago
You want to invest in a project in LaLaLand. The project has an initial cost of LLL 757,000 and is expected to produce cash infl
Lelu [443]

Answer:

194,112.8

Explanation:

The computation of  Net Present Value is shown below:-

Net Present Value = Present value of cash inflows - Present value of Cash outflows

= -757,000 + 396,000 × PVAF (12%, 3 years)

= -757,000 + 396,000 × 2.4018

= -757,000 + 951,112.8

= LLC 194,112.8

= 194,112.8

Therefore for computing the net present value we simply applied the above formula.

8 0
3 years ago
Which is not a reason for supporting ethical relativism?
raketka [301]

This is not the reason why not support ethical relativism; Ethical relativism holds that there is a right and wrong, even though we do not agree about what is right and wrong and If people disagree about some moral matter, their disagreement will always be due to their having different moral values.

4 0
3 years ago
Siebel Incorporated, a non-publicly traded company, has 2009 after-tax earnings of $25 million, which are expected to grow at 6
Readme [11.4K]

Answer:

Answer of each requirement is given seperatly below.

a What is the value of Siebel using the DCF method?

Value under DCF = CF * (1+growth rate)/ (WAAC" -Growth rate)

Putting values (assuming after tax earning is all in cash)

Value of SI = 25 (1+6%)/ 20%-6% = 189 million dollars

 

"WAAC calculation

Here WAAC is equal to cost of equity (ke) as company is debt free.

so

Ke = risk free rate + beta (risk premium)

    = 5 + 2.5 (6) = 20%

b What is the value using the comparable recent transactions method?

Based on recent tansaction the value of siebel incorporated will be               calculated as shown below

 Value of SI = Profit afte * 10 = 25 * 10 = 250 million dollars

Publicly-traded Rand Technology, a direct competitor of Siebel's sale is taken as bench mark.

c What would be the value of the firm if we combine the results of both methods?

By combining value of both value technique we get 189 + 250 = 439 million dollars.

8 0
3 years ago
Resource management for most service-providing organizations generally requires as many intermediate levels of planning as it do
devlian [24]

Answer:

FALSE

Explanation:

The resource management refers to how efficient and effective are used the organization's resources.

We must understand for resources the following:

  • financing
  • finished goods
  • raw materials
  • human resources
  • information and technology
  • natural resources

As a service-providing organization do not employs a manufacturing process theyr levels of planning are lower in a service-providing organization

5 0
3 years ago
Other questions:
  • The __________ insures deposits held in credit unions.
    6·2 answers
  • How have the division and coordination of labor evolved at merritt's bakery from its beginnings to today?
    15·1 answer
  • The managerial function of ______ involves monitoring performance, comparing it to goals, and taking corrective action when need
    11·1 answer
  • Economically rational means that consumers and firms
    5·1 answer
  • Rosa has a 10% chance of getting sick in the next year. If she gets sick, her medical bills will amount to $500. She has a wealt
    14·1 answer
  • A project is exceptionally risky might still be undertaken by a firm if they have several other projects underway that are consi
    7·1 answer
  • Identify one environmental factor or risk that affects the decision-making opportunities within your organization. Provide a bri
    14·1 answer
  • All of Armand's employees make the same amount of money but he thinks they lie to each other about how much they make. To stop t
    14·1 answer
  • Bonita earns $31,000 from her job, and she has $1,000 of interest income. She has itemized deductions of $35,000. There are no c
    11·1 answer
  • For which capital component must you make a tax adjustment when calculating a firmâs weighted average cost of capital (WACC)?
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!