Exercise 20-17 Preparation of cash budgets (for three periods) LO P2 Kayak Co. 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 January $ 525,000 $ 475,000 February 400,000 350,000 March 450,000 525,000 According to a credit agreement with its bank, Kayak requires a minimum cash balance of $30,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 $30,000 on the last day of each month. The company has a cash balance of $30,000 and a loan balance of $60,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. )

Answers

Answer 1

The preparation of the cash budgets for the first three months of next year for Kayak Co. is as follows:

                                              January        February          March

Beginning cash balance      $30,000       $30,000        $69,294

Cash receipts                       525,000       400,000        450,000

Total cash available          $555,000     $430,000       $519,294

Cash disbursements           475,000        350,000        525,000

Ending cash balance          $80,000       $80,000          ($5,706)

Required minimum balance 30,000         30,000           30,000

Available for Loan Payment 50,000        50,000         ($36,000)

Loan Interest & Principal Payment:

Interest repayment                 $600            $106

Loan:

Beginning balance           $60,000      $10,600

Loan repayment              ($49,400)    ($10,600)

Ending balance                 $10,600       $0

Data and Calculations:

Month        Cash Receipts   Cash Disbursements

January       $ 525,000             $ 475,000

February        400,000                350,000

March            450,000                525,000

Minimum required cash balance = $30,000 per month-end

Loan limit = $150,000

Monthly interest rate = 1%

Interest payment and principal repayment = last day of each month

Interest computation = beginning balance

Beginning cash balance = $30,000

Beginning loan balance = $60,000

The beginning cash balance of March is $69,294 ($80,000 - $106 - $10,600)

Thus, at the end of March, Kayak Co. needs to borrow $36,000.

Learn more about preparing the cash budget at brainly.com/question/8707644


Related Questions

What are marketing information systems?

Answers

Answer:

A marketing information system, or an MIS, is a system for gathering, storing, analyzing and distributing valuable marketing data to help marketers make better decisions

An MIS is a system used for gathering, analyzing, storing and distributing marketing information to help the marketers in making decisions.

What system is based on the supply and demand of goods to make a profit?.

Answers

Answer:

B : market economy

Explanation:

Describe two places where you have seen dimensioned drawings. explain why the dimensions were needed for both situations.

Answers

Answer:

house plans and building a car

Explanation:

Knowing the educational requirements for a job you are interested in is very important. For example, to become a doctor would require you to go to school for many years, but to become a carpenter would require you to complete a specialized program through a trade school.

In the space below, write 2 to 3 sentences explaining why knowing the educational requirements for a job you are interested in is important.

Answers

Answer: It is very important because you need to be prepared to invest the time and money necessary to gain the required skills.

Explanation:

How do trade agreements of international organizations affect trade? by incentivizing the development of trade policies by eliminating tariffs and taxes on imports and exports by encouraging countries to provide open access to trade by helping smaller countries compete in the world market.

Answers

One way in which trade agreements by international organizations affect trade is by encouraging countries to provide open access to trade.

How do International Organizations affect trade?

International organizations agree to treaties with nations that encourage those nations to allow free access to trade.

This ensures that more trade happens because people and nations would be free to import and export which would increase trade volumes as people take advantage.

Find out more on trade agreements at https://brainly.com/question/374195.

Answer: C. by encouraging countries to provide open access to trade

Explanation:

right on edge 2022

Debts and obligations of a business are referred to as:.

Answers

Answer:

Liabilities

Explanation:

Liabilities are the debts and obligations that a business owes.

After 7 years of working for a company that installed underground sprinkler systems for homeowners, terrance was ready to venture into his own business. As he prepared his swot analysis, he evaluated where he stood at this time. He was fortunate to have $120,000 financing to get the business under way. He knew of three skilled installers who were willing and interested to work for him, and he was aware that new construction was at an all-time low, with several residential properties being foreclosed. In reviewing his list, you would categorize these events as.

Answers

In reviewing his SWOT analysis, Terrance, who was ready to venture into his own business after working for 7 years as an underground sprinkler installer, has two strengths and one threat.

What is a SWOT analysis?

A SWOT analysis is a framework for analyzing a company's competitive position to enable the development of competitive strategies.

A SWOT analysis includes Strengths, Weaknesses, Opportunities, and Threats.

Thus, for Terrance, he has two strengths ($120,000 financing and three skilled installers who were willing and interested in working for him) and one threat (low construction activities) with increasing foreclosures.

Learn more about SWOT analysis at https://brainly.com/question/6954185

_______________ is the degree to which decision-making authority is retained at higher managerial levels a. Formalization b. Unification c. Centralization d. Specialization

Answers

There are various organizations structure. one of it is centralization. Centralization is the degree to which decision-making authority is retained at higher managerial levels.

Features of Centralization

In a centralized company, cogent decisions are made at topmost levels of the hierarchy, whereas in decentralized companies, decisions are made and problems are solved at lower levels by employees who are closer to the problem.

Advantages of centralization

Some employees are more okay in an organization where their manager authoritatively gives instructions and makes decisions. Centralization can also lead to operational efficiency because there will be no time wasting, particularly if the company is operating in a stable environment. Strategic process and content as mediators between organizational context and structure.

Therefore, the answer is centralization option C.

learn more about centralization: https://brainly.com/question/1288780

what are the two factors that go into which item is thought of as bought first, etc., when choosing between several possible purchases.

Answers

Answer:

Fifo

Explanation:

Because the stock that is bought first should be the one to be purchased first

Use your knowledge of the leadership grid to select the correct management style for each description.

Answers

The most appropriate management style for description A would be Country Club Management because they are related in different ways.

What is leadership grind?

Leadership grind is a text published in 1964 by Robert Blake and Jane Mouton. In this text, forms of management are classified as a tool for company managers to develop a management style.

One of the management styles proposed in this book is the country club manager, who is characterized by focusing his concern on the people who make up his work group, not worrying about production. This produces a comfortable work environment with poor performance.

Based on the foregoing, the most appropriate style for description A. would be Country Club Management, since it would foster a good work environment without looking at the team's results.

Note: This question is incomplete because there is some information missing. Here is the complete information:

A. Thoughtful, attention to people's needs for satisfying relationships leads to a comfortable and friendly organizational atmosphere and work pace.

Learn more about management in: https://brainly.com/question/14523862

Financial incentives given by the government to corporations, individuals, or other governments for the purpose of encouraging certain activities or behaviors are ______.

a. Grants

b. Entitlements

c. Welfare programs

d. Subsidies

Answers

Answer:

It os D, subsidies. this is correct.

Dane is a single father with one qualifying dependent child. He has AGI of $154,000 and paid $9,100 to a qualified day care center for the two children. What amount of child and dependent care credit can Dane receive in 2021? Multiple Choice $0. $2,800. Incorrect $8,000. $9,600

Answers

Because Dane is a single father with one qualifying dependent child, the child and dependent care credit will be $8,000.

What is the child and dependent care credit?

This is a tax benefit that is made for qualifying persons that provide care for someone else.

The child and dependent care credit is for up to of $8,000 in qualified expenses for a qualifying child, and up to $16,000 for two or more children.

Hence, because Dane is a single father with one qualifying dependent child, the credit will be $8,000.

Therefore, the Option D is correct.

Read more about care credit

brainly.com/question/14270987

All companies operate in a broad ______-environment that is made up of six components, including political factors and technological factors. Multiple choice question. micro meso para macro

Answers

Answer:

The word that is underlined, that's the answer; Macro

Explanation:

hope this helps.

Answer:

the answer is macro .

Explanation:

MARK ME AS A BRIANLIEST

What element of the marketing mix has a unique role in that it is the place where all other business decisions come together?.

Answers

The element of marketing mix that has a unique role in that it is the place where all other business decisions come together is known as Place

What is marketing mix?

The marketing mix relates to the collection of steps or strategies employed to sell the brand or commodity on the market by an company.

Elements of marketing mix include:

PlacePricePromotionProduct

Hence, the element of marketing mix that has a unique role in that it is the place where all other business decisions come together is known as the place.

Learn more about marketing mix here : https://brainly.com/question/26156175

Darren has borrowed $100$ clams from ethan at a $10\%$ simple daily interest. meanwhile, fergie has borrowed $150$ clams from gertie at a $5\%$ simple daily interest. in how many days will darren and fergie owe the same amounts, assuming that they will not make any repayments in that time period?

Answers

Answer:

20

Explanation:

start doing math

In 20 days Darren and Fergie owe the same amounts.

What is simple interest?

simple interest is primarily based on the primary quantity of a  or the primary deposit in a savings account. simple interest does not compound, which means that a creditor will best pay interest on the main amount and a borrower could by no means pay extra interest at the previously gathered interest.

calculation:-

10% is on $100 is = $10

5% SI on $150 = $7.5

Learn more about simple interests here:-https://brainly.com/question/2294792

#SPJ2

Caspion Corporation makes and sells a product called a Miniwarp. One Miniwarp requires 6.5 kilograms of the raw material Jurislon. Budgeted production of Miniwarps for the next five months is as follows:
August 23,000 units
September 21,700 units
October 23,100 units
November 24,300 units
December 24,000 units
The company wants to maintain monthly ending inventories of Jurislon equal to 20% of the following month's production needs. On July 31, this requirement was not met since only 11,200 kilograms of Jurislon were on hand. The cost of Jurislon is $22 per kilogram. The company wants to prepare a Direct Materials Purchase Budget for the next five months.
The total cost of Jurislon to be purchased in August is:_______.

Answers

Assuming the company wants to prepare a Direct Materials Purchase Budget for the next five months. The total cost of Jurislon to be purchased in August is:$3,663,220.

Total cost

Using this formula

Total cost=(Desired ending inventory+ Required for production-Ending inventory)×Rate per kilogram

Total cost=[(21,700×6.5×20%)+(23,000×6.5)-11,200]×$22 per kilogram

Total cost=(28,210+149,500-11,200)×$22 per kilogram

Total cost=166,510×$22 per kilogram

Total cost=$3,663,220

Inconclusion the total cost of Jurislon to be purchased in August is:$3,663,220.

Learn more about Total cost here:https://brainly.com/question/25109150

Undue influence cases often involve a relationship of trust and confidence between the contracting parties.
a. True
b. False

Answers

True

why?

-cuz I just know

Definitions Types of Companies a. Purchases goods that are primarily in finished form for resale to customers. b. Records revenues when providing services to customers. c. Produces the goods they sell to customers.

Answers

The definitions of types of Companies is one that c. Produces the goods they sell to customers.

What is a company?

A company serves as the legal entity formed by a group of individuals for production of goods and services.

They do engage in and operate a business which could be commercial or industrial enterprise.

Learn more about company at;

https://brainly.com/question/24448358

When costs to purchase inventory are rising, using LIFO leads to reporting ______ cost of goods sold and ______ net income than FIFO.

Answers

When costs to purchase inventory are rising, using LIFO leads to reporting lower cost of goods sold and higher net income than FIFO.

LIFO and FIFO

LIFO means last in last out  while FIFO represent first in first out. In a situation were price of goods and service are falling using LIFO tend to assume that the newer and less expensive inventory is sold out first.

This tend to lead to lower cost of goods sold and higher net income.

Inconclusion when costs to purchase inventory are rising, using LIFO leads to reporting lower cost of goods sold and higher net income than FIFO.

Learn more about LIFO and FIFO here:https://brainly.com/question/24938626

In+a+survey+conducted+on+an+srs+of+200+american+adults,+72%+of+them+said+they+believed+in+aliens. +give+a+95%+confidence+interval+for+percent+of+american+adults+who+believe+in+aliens

Answers

Based on the size of the sample, the 95% confidence interval for American adults who believe in aliens is (0.6577719, 0.7822281).

What is the confidence interval?

With a 95% interval, we can find the Z score using the Z table to be 1.96.

The 95% interval here would therefore be:

Lower limit:

= (Proportion that believes in Aliens - 1.96 x √((Proportion that believes in aliens x Percentage that doesn't)) / Sample size

= 0.72 - 1.96 x √((0.72 * 28) / 200)

= 0.6577719

Upper limit:

=  0.72 + 1.96 x √((0.72 * 28) / 200)

= 0.7822281

Find out more on confidence intervals at https://brainly.com/question/16974109.

You have been at fault in your second accident in six months. your insurance company is going to increase your annual premium by 28%. your current annual premium is $975. what will your adjusted premium be?.

Answers

Your adjusted premium based on a current annual premium of $975, increased by a 28% penalty for being at fault in the second accident in six months, is $1,248.

What is the annual premium?

The annual premium is the amount that a policyholder pays to the insurance company for a one-year insurance policy.

The annual premium helps to guarantee payment of indemnity when the covered events occur.

This implies that the annual premium is a periodic contribution that helps in the pooling of risks by the insured to help the insurer meet its indemnity obligations.

Data and Calculations:

Current annual premium = $975

Increase in annual premium = 28%

Adjusted premium = $1,248 ($975 x 1.28)

Thus, the adjusted premium based on a current annual premium of $975, increased by a 28% penalty for being at fault in the second accident in six months, is $1,248.

Learn more about the annual premium at https://brainly.com/question/25280754

References that employers trust for the most accurate reporting include _____. a. friends b. relatives c. counselors d. parents please select the best answer from the choices provided a b c d

Answers

Counselors are one of the references that employers trust for the most accurate reports. As a result, option (c) is the proper response.

Which are considered the most-trusted references by the employer?

Counselors are one of the references that employers trust for the most accurate reports.

Employers do not trust the friends, relatives, and parents of prospective employees or employees to provide an accurate report because they believe they are not professional enough and that because of their proximity to the employee, they may provide false information in order to benefit the employee.

Employers view counselors as more professional and more likely to provide accurate information.

For more information about employer references, refer below

https://brainly.com/question/18504651

Which ics functional area arranges for resources and needed services.

Answers

The ICS functional area that arrange for resources and needed services is known as logistics.

What is ICS?

ICS is an acronym for Incident Command System. It is a management system designed to enable effective and efficient domestic incident management.

The five major ICS functional areas are:

CommandOperationsPlanningLogisticsFinance/administration.

Hence, Logistics as an ICS functional area is responsible for arranging for resources and needed services to support achievement of the incident objectives.

Learn more about ICS here : https://brainly.com/question/10695996

Terrel is designing and maintaining a web page for a local company. In which career pathways would Terrel be involved?

Programming and Software Development, and Network Systems
Network Systems and Interactive Media
Information Support and Services, and Programming and Software Development
Interactive Media, and Information Support and Services

Answers

Answer:

C. Information Support and Services, and Programming and Software Development

Explanation:

I got it right on edge. trust me.

Answer:

C. Information Support and Services, and Programming and Software Development

Explanation:

Edge

What is the purpose of establishing economic sanctions? to enter into an alliance with a country to honor the terms of a trade agreement to pressure a nation to change its policies to provide financial aid to a nation in need

Answers

The purpose of establishing economic sanctions is to pressure a nation to change its policies.

What is economic sanction?

Economic sanction refers to the states use economic pressure (trade and financial restrictions) against other states to create policy or behavioral change.

Various international bodies like UN, NATO uses economic sanctions against nations whose policy is against international agreeable standards.

Hence, the purpose of establishing economic sanctions is to pressure a nation to change its policies.

Learn more about economic sanctions here : https://brainly.com/question/873558

Answer:

c

Explanation:

What is systematic risk? Multiple choice question. It is a risk that is caused by failure of the internal control system of a corporation. It is a risk that increases in a systematic, gradual fashion. It is a risk that affects only one or a few assets. It is a risk that pertains to a large number of assets.

Answers

Systematic risk is D. It is a risk that pertains to a large number of assets.

What is systematic risk?

It should be noted that systematic risk simply refers to the risk that's inherent to the entire market.

In this case, systematic risk is the risk that pertains to a large number of assets. It is also known as volatility.

Learn more about systematic risk on:

https://brainly.com/question/15907254

Employee ________ are perks that are provided in addition to salaries and wages, such as all or part of medical, dental, life and disability insurance.

Answers

The perks that are provided in addition to salaries and wages, such as all or part of medical, dental, life, and disability insurance are known as Employee Benefits.

What are Employee Benefits?

Employee benefits are benefits that include all types of nonwage compensation that are given to employees in addition to their normal wages and salaries.

These benefits cover a lot of things including transportation, group life insurance, medical benefits, and even disability insurance. These are perks that are added to the normal wage of an employee.

Learn more about Employee Benefits here:

https://brainly.com/question/5144146

_____ adjust vehicle ratings to reflect just those individuals who match the advertiser’s target audience.

Answers

Answer:

Target Rating Points adjust vehicle ratings to reflect just those individuals who match the advertiser’s target audience.

Explanation:

Target Rating Points (TRPs) are a refinement of gross rating points, or GRPs. GRPs relate to the "total audience" exposure to advertising messages, whereas TRPs relate to the "target audience" exposure.

-Justin :)

How can you stop inappropriate text and pictures from appearing in search results? A. Use keywords. B. Change filtering settings. C. Click sponsored links. D. Add bookmarks.

Answers

The major step to stop inappropriate text and pictures that appear in search results is by changing the filtering settings.

What is the inappropriateness of text and pictures?

An inappropriateness of text and pictures is that are not suitable or the quality of the text and pictures is unfit.

A change in filtering settings can help in stopping the inappropriate text and pictures that appear in search results.

Therefore, B is the correct option.

Learn more about the Inappropriateness of text here:

https://brainly.com/question/4530171

What would be the best reason for the United States to provide military aid to another country? to protect an established alliance to improve the other nation’s reputation to help the other country gain greater power to result in a new trade agreement or alliance.

Answers

Answer: A protect an established alliance

Explanation:

that’s the answer on Ed2022

The best reason for the United States to provide military aid to another country is to protect an established alliance.

What is the reason the US providing military aid to other nations?

The US wants to give security to other nations and establish its supremacy among the nations. It shows its power to big nations by collaborating with small nations.

Therefore, the US form an alliance with these nations and get their support by involving in trading and other economic agreements with them.

Learn more about the US here:

https://brainly.com/question/1219822

Other Questions
discuss the notion of urbanization as adouble edged sword Which BCMAP situation requires a direct comment on the USMC Fitness Report?Select the best re Which statement best characterizes how us citizens reacted to the tet offensive? Is this a function pls someone tell me What happens when plants don't get sunlight in space What system plays a vital role in the existence of the human species?What's the ans? The region that receives the least rainfall is Southwest Asia is the ___. A. Fertile CrescentB. Persian Gulf CoastC. Arabian Peninsula D. Elburz Mountains PLEASE HELP ME DUE IN 1 MIN WILL GIVE BRAINLIEST, 100 POINTS, AND 5 STARS IF RIGHT!!!!! Need help now !!!!!!!!!!!!!9 Even after two years, no one can explain the strange phenomenon that occurred in my little town. I dont need an explanation, though. The warm summer winds are starting to blow, and I cant wait to see what comes behind them. A synonym for the word phenomenon in paragraph 9 is A) carnival. B) occurrence. C) realization. D) celebration. A figure was transformed on a coordinate grid using the rule (x,y) Will give brainliest, thanks, and 5 stars! LOTS OF POINTS! 50 POINTS!I need help with these questions! Please help me. The choices are all true/false. Please help me!!!!!!Please provide in depth explanation too!! 5x + 2 =3x - 14Simplify and solve the followinghey New materials can be constructed molecule-by-molecule and atom-by-atom using ______________ in their design. by supporting with practical examples how would you argue out the statement that, "perception in most cases are subjective, irrational, and marred with errors?" Your credit score does not affect your:A. chances of landing a new job.B. ability to rent an apartment.C. ability to get a car loan.D. yearly income. In general, the frequency of crossing over between two linked genes depends on what? How far apart they are on the chromosome The characteristics that the genes code for Whether the genes are dominant or recessive The phase of meiosis in which the crossing over occurs Please answer all of these!! Please quickly!! The weather forecast reports that the probability of rain today is 50% and the probability of rain tomorrow is 25%. What is the probability that it will rain on both days? Apple decided to walk [tex]9\frac{3}{10}[/tex]mi from his house to the beach. In the first hour, he walked [tex]3\frac{4}{5}[/tex]mi. In the second hour he walked [tex]2\frac{9}{10}[/tex]mi. How much farther did he have to go?Please show your work! Help? im confused plss!Find the area of the regular polygon with the given radius or apothem.