8 10 points Exercise 20-17 (Algo) Preparation of cash budgets (for three periods) LO P2 Kayak...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6648ef4f6fdf8_8866648ef4edd939.jpg)
Transcribed Image Text:
8 10 points Exercise 20-17 (Algo) Preparation of cash budgets (for three periods) LO P2 Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash payments eBook Hint January February March $ 515,000 404,500 482,000 $ 456,300 345,800 521,000 Kayak requires a minimum cash balance of $40,000 at each month-end. Loans taken to meet this requirement charge 1%, interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $40,000 is used to repay loans at month-end. The company has a cash balance of $40,000 and a loan balance of $80,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.) References KAYAK COMPANY Cash Budget January February March Beginning cash balance $ 40,000 Total cash available Total cash payments Preliminary cash balance Loan activity Ending cash balance Loan balance - Beginning of month Additional loan (loan repayment) Loan balance, end of month Loan balance $ 80,000 8 10 points Exercise 20-17 (Algo) Preparation of cash budgets (for three periods) LO P2 Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash payments eBook Hint January February March $ 515,000 404,500 482,000 $ 456,300 345,800 521,000 Kayak requires a minimum cash balance of $40,000 at each month-end. Loans taken to meet this requirement charge 1%, interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $40,000 is used to repay loans at month-end. The company has a cash balance of $40,000 and a loan balance of $80,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.) References KAYAK COMPANY Cash Budget January February March Beginning cash balance $ 40,000 Total cash available Total cash payments Preliminary cash balance Loan activity Ending cash balance Loan balance - Beginning of month Additional loan (loan repayment) Loan balance, end of month Loan balance $ 80,000
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
a) Construct a diffusion tree of prices and probabilities for an asset tree using the following information: Starting Price (period 0) 100 Diffusion rate 4.00% Probability of a price rise 0.6 Number...
-
IMPORTANT: As stated in the hints, please DO NOT use lookaheador lookbehind patterns. The solution cannot use them. Please verifythat your solution works for all the example strings in thequestion....
-
Quantum Technologies Ltd reported that the fair market value of its assets was 900,000 and the total liabilities amounted to 400,000. The net income for the year was 120,000. Requirements: Calculate...
-
8 for 0 < < 6 for 6
-
On January 1, 2011, Standard Co. bought 40% of the outstanding common stock of Exchange Corp. for $380,000 cash. Standard Co. accounts for this investment by the equity method. At the date of...
-
When might activity-based costing be preferred over using a relative amount of product sales in allocating selling and administrative expenses to products? AppendixLO1
-
Do many people annoy or irritate you? True/False LO.1
-
Prescrip Co. began operations in 2012. The cost and fair values for its long-term investments portfolio in available-for-sale securities are shown below. Prepare Prescrips December 31, 2013,...
-
Nanimahoo Marketing Services has been operating for several years. It showed the following trial balance information in eparing financial statements from a trial balance alphabetical order) for the...
-
Patterson Lawn Company is the primary provider of lawn care maintenance in the city of Jasper. The Company has two operating departments, one that performs lawn care services for commercial...
-
A retail product has the following standard costs established: Direct Material per unit - 2 pounds at $5 a pound Direct Labor per unit - 3 hours at $12 an hour Manufacturing Overhead - $5 per labor...
-
In a recent year, the Better Business Bureau settled 75% of complaints they received. (Source: USA Today, March 2, 2009) You have been hired by the Bureau to investigate complaints this year...
-
A 1200-ft equal tangent crest vertical curve is currently designed for 50 mph. A civil engineering student contends that 60 mph is safe in a van because of the higher driver's eye height. If all...
-
Required information [The following information applies to the questions displayed below.] Victory Company uses weighted-average process costing to account for its production costs. Conversion cost...
-
Finer, % 100 90 80 70 60 50 40 30 20 10 0 0.01 0.1 1 Size, mm L 10 100 Figure shows a grain size distribution curve of soil. Estimate the coefficient of curvature (Cc) of this soil.
-
You have a credit card debt which is attracting interest at 18:5% per annum (APR) with monthly compounding. The bank has told you that if you pay $328:37 per month it will take you exactly 107 months...
-
TRUE-FALSE QUESTIONS 1. In terms of preliminary analytical procedures, assume that the company has introduced a new product with a low price point and significant customer demand. The auditor would...
-
7. What is the explanation for the difference between the consolidated cost of goods sold and the combined cost of goods sold of the two affiliated companies? Prepare a schedule reconciling combined...
-
P 11-6 [Based on AICPA] Separate and consolidated financial statementsentity theory The individual and consolidated balance sheets and income statements of P and S Companies for the current year are...
-
10. Beginning with the $200,000 balance in P Companys retained earnings at the end of the current year, prepare a schedule in which you derive the $217,000 balance of consolidated retained earnings...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App