Exercise 6: Luna Ple is preparing the cash budget the year 20X0. The following table characterises the cash inflows and outflows of the business. (unit of measure: Smil) 1" Quarter 2d Quarter 3d Quarter 4th Quarter 20X0 Cash inflow from sales budget 240 280 460 500 1,480 Cash outflow from direct material budget 120 140 230 250 740 Cash outflow from direct labour budget 32 48 80 80 240 Cash outflow from overheads cost budget 62 78 110 110 360 Cash outflow from sales and admin cost budget 58 62 70 70 260 Besides the above cash flows, the expected cooperation income tax is $20mil per quarter and an amount of $40mil dividend would be paid out to shareholders at 4th quarter. The opening balance of cash for the year is $320mil. The management wish to maintain the minimum cash reserve $300mil per quarter. Prepare the cash budget for the year 20X0 given that in case of borrowing to maintain the cash reserve level, an interest of 12% per year annum is applied. The amount of borrowing would be released at the last day of each quarter. The reimbursement is expected at the year end.
Exercise 6: Luna Ple is preparing the cash budget the year 20X0. The following table characterises the cash inflows and outflows of the business. (unit of measure: Smil) 1" Quarter 2d Quarter 3d Quarter 4th Quarter 20X0 Cash inflow from sales budget 240 280 460 500 1,480 Cash outflow from direct material budget 120 140 230 250 740 Cash outflow from direct labour budget 32 48 80 80 240 Cash outflow from overheads cost budget 62 78 110 110 360 Cash outflow from sales and admin cost budget 58 62 70 70 260 Besides the above cash flows, the expected cooperation income tax is $20mil per quarter and an amount of $40mil dividend would be paid out to shareholders at 4th quarter. The opening balance of cash for the year is $320mil. The management wish to maintain the minimum cash reserve $300mil per quarter. Prepare the cash budget for the year 20X0 given that in case of borrowing to maintain the cash reserve level, an interest of 12% per year annum is applied. The amount of borrowing would be released at the last day of each quarter. The reimbursement is expected at the year end.
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 1PB
Related questions
Question
100%
Please help with this
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
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.Recommended textbooks for you
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning