Premium-Inn had the following estimated cash flows for the first quarter:    January  February  March  Quarter  Cash receipts  £800,000  £1,000,000  £1,300,000  £3,100,000  Cash disbursements  £1,000,000  £1,000,000  £1,000,000  £3,000,000       The company begins the year with £100,000 in cash and requires a minimum cash balance of £30,000. The company may borrow any amount from a local bank at an annual interest rate of 4%, The borrowing must occur at the beginning of any month and all repayments must be made at the end of any month. Interest must be repaid at the time of loan repayment.     Required:  In good form, prepare the company’s cash budget for the upcoming year.

Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter8: Budgeting
Section: Chapter Questions
Problem 19E: Schedule of cash payments for service company Horizon Financial Inc. was organized on February 28....
icon
Related questions
Question
100%

Premium-Inn had the following estimated cash flows for the first quarter: 

 

January 

February 

March 

Quarter 

Cash receipts 

£800,000 

£1,000,000 

£1,300,000 

£3,100,000 

Cash disbursements 

£1,000,000 

£1,000,000 

£1,000,000 

£3,000,000 

    

The company begins the year with £100,000 in cash and requires a minimum cash balance of £30,000. The company may borrow any amount from a local bank at an annual interest rate of 4%, The borrowing must occur at the beginning of any month and all repayments must be made at the end of any month. Interest must be repaid at the time of loan repayment.  

 

Required: 

In good form, prepare the company’s cash budget for the upcoming year. 

Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Receivables Management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Entrepreneurial Finance
Entrepreneurial Finance
Finance
ISBN:
9781337635653
Author:
Leach
Publisher:
Cengage
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning