JanuaryFebruaryMarch$ 518,000406,500478,000Kayak requires a minimum cash balance of $40,000 at each month-end. Loans taken to meet this requirement charge 1%, interest permonth, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminarycash balance above $40,000 is used to repay loans at month-end. The company has a cash balance of $40,000 and a loan balanceof $80,000 at January 1.Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (If any) shouldbe Indicated with minus sign.)Beginning cash balanceAdd: Cash receiptsTotal cash availableLess: Cash payments forAll items excluding interestInterest revenueTotal cash paymentsPreliminary cash balance$ 465,900354,400535,000Loan activityAdditional loan (loan repayment)Ending cash balanceLoan balance - Beginning of monthAdditional loan (loan repayment)Loan balance, end of monthKAYAK COMPANYCash Budget$January40,000 $518,000558,000465,900465,900Loan balance$80,000February40,000 $406,500446,500354,400354,400$March80,000478,000558,000535,000535,0000

January February March $ 518,000 406,500 478,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. Beginning cash balance Add: Cash receipts Total cash available $ 465,900 354,400 535,000 Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (If any) should be Indicated with minus sign.) Less: Cash payments for All items excluding internet KAYAK COMPANY Cash Budget $ January 40,000 $ 518,000 558,000 February 40,000 406,500 446,500 $ March 80,000 478,000 558,000

January February March $ 518,000 406,500 478,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. Beginning cash balance Add: Cash receipts Total cash available $ 465,900 354,400 535,000 Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (If any) should be Indicated with minus sign.) Less: Cash payments for All items excluding internet KAYAK COMPANY Cash Budget $ January 40,000 $ 518,000 558,000 February 40,000 406,500 446,500 $ March 80,000 478,000 558,000

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

please complete the table below for End of Months: 2 , 13, 24, and 36
all first four months please
Please do not give image format
On January 2nd, Mobile Sales borrows $20,000 cash on a note payable from Ethical Lenders with terms 90 days, 5%. Mobile Sales and Ethical Lenders uses a 360-day year for interest calculations. Mobile Sales makes adjusting entries at the end of each calendar quarter. Journalize the initiation of the loan, the recognition of interest expense for the quarter and the payment of the note on its due date (round to the even dollar).
Bruce Wayne borrowed $14 300.00 for investment purposes on May 19, on a demand note providing for a variable rate of interest and payment of any accrued interest on December 31. He paid $1,300.00 on June 28, $1,450 on September 25, and $4,200.00 on November 15. How much is the final payment on December 31 if the rate of interest was 11.5% on May 19; 8.21% effective August 1; and 6.35% effective November 1? Payment Date Payment Interest Cost Principal Portion Outstanding Balance 19-May 14300 28-Jun 1300 0 1300 13000 25-Sep 1450 0 1450 11550 15-Nov 4200 0 4200 7350 31-Dec 7350 0 7350 0 Interest Calculation Dates Days Time = Days/365 R (rate of interest) Interest cost First Interest Payment May 19 to June 28 Second Interest Payment June 29 to July 31 Aug 1 to Sept 25 Total Interest Payment 0 Third Interest Payment Sept 26…
Do not give image format
estion list Question 1 Question 2 Question 3 elp n ✓ Requirements You're an Artist prepares and packages paint products. You're an Artist has two departments: Blending and Packaging. Direct materials are added at the beginning of the blending process (dyes) and at the end of the packaging process (cans). Data from the month of May for the Blending Department are as follows: View the data from May. You're an Artist completed the following production cost report for its Blending Department for the month of May: View the assignment of costs. Conversion costs are added evenly throughout each process. The company uses the weighted-average method. Read the requirements. Requirement 1. Prepare the journal entries to record the assignment of direct materials and direct labor and the allocation of manufacturing overhead to the Blending Department. Also, prepare the journal entry to record the costs of the gallons completed and transferred out to the Packaging Department. Assume labor costs are…
Note:- • Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. • Answer completely. • You will get up vote for sure.
Colson Company has a line of credit with Federal Bank. Colson can borrow up to $800,000 at any time over the course of the calendar year. The Unit 10 Template shows the prime rate expressed as an annual percentage along with the amounts borrowed and repaid during the year. Colson agreed to pay interest at an annual rate equal to 2 percent above the bank's prime rate. Please note that the interest rate for each month must be converted into a monthly rate by dividing by 12. Funds are borrowed or repaid on the first day of the month. Interest is payable in cash on the last day of the month. The interest rate is applied to the outstanding monthly balance. For example, Colson pays ((4 percent + 2 percent)/12) monthly interest on $80,000 for the month of January
Loans Scotiabank approved a $230.000.00 line of credit for Buhler Industries at prime + 1%. It requires only the repayment of accrued interest on the 24th of each month which is automatically deducted from the checking account of Buhler Industries. Buhler took out an advance on December 6 for $160,000.00 and made a payment of $130,000.00 on January 16 The prime rate was 5.25% initially and increased to 6.5% on January 7. Complete the repayment schedule below by filling in the payment and principal amounts. Payment Date Balance Annual before Interest Transaction Rate Number of Days Interest Accrued Charged Interest (+) or Principal Balance after Advance Amount Transaction (-) Dec 6 $160,000.00 Dec 24 $160.000,00 $160,000.00 Jan 7 Jan 16 $160,000.00 $30,000.00 Jan 24 6.25% 18/365 7.5% 8/365 6.25% 14/365 $383.56 7.5% 9/365 $295.89 $679.45 $49.32 $728.77 $493.15 $493.15 $383.56 $160,000.00 $160,000.00 $30,000.00 $30,000.00 Notes You con can partial credit on this problem
On January 1, Year 1, Mahoney Company borrowed $168,000 cash from Sun Bank by issuing a 5-year, 8% term note. The principal and interest are repaid by making annual payments beginning on December 31, Year 1. The annual payment on the loan equals $42.077, What is the amount of principal repayment included in the payment made on December 31, Year 1? Multiple Choice Ο Ο Ο Ο $13,440 $37.467 $40,725 $28,637
A $34,000 new car loan is taken out with the terms 9% APR for 48 months. How much are monthly payments on this loan? OA. $846.09 OB. $930.70 OC. $1,015.31 OD. $1,099.92