You recently began a job as an accounting intern at Big Sky Adventures. Your first task was to help prepare the cash budget for February and March. Unfortunately, the computer with the budget file crashed, and you did not have a backup or even a hard copy. You ran a program to salvage bits of data from the budget file. After entering the following data in the budget, you may have just enough information to reconstruct the budget. i (Click the icon to view information on borrowing cash.) (For amounts with a zero balance, make sure to enter "0" in the appropriate cell. Enter cash deficiencies with a minus sign or parentheses. Enter the net total effects of financing with a minus sign or parentheses when the amount is a net outflow. Round the interest expense to the nearest whole dollar.) Big Sky Adventures Ltd. Cash Budget February and March More info February March 16,200 Beginning cash balance Cash collections 0 Big Sky Adventures eliminates any cash deficiency by borrowing the exact amount needed from Caisse Populaire, where the current interest rate is 7%. Big Sky Adventures pays interest on its outstanding debt at the end of each month. The company also repays all borrowed amounts at the end of the month as cash becomes available. Cash from sale of plant assets 106,400 Cash available Cash payments: Purchases of inventory 47,800 Print Done Operating expenses 98,500 Total payments (1) Ending cash balance before financing 21,000 Minimum cash balance desired Cash excess (deficiency) Financing of cash deficiency $ $ 80,200 2,600 41,900 23,600 21,000
You recently began a job as an accounting intern at Big Sky Adventures. Your first task was to help prepare the cash budget for February and March. Unfortunately, the computer with the budget file crashed, and you did not have a backup or even a hard copy. You ran a program to salvage bits of data from the budget file. After entering the following data in the budget, you may have just enough information to reconstruct the budget. i (Click the icon to view information on borrowing cash.) (For amounts with a zero balance, make sure to enter "0" in the appropriate cell. Enter cash deficiencies with a minus sign or parentheses. Enter the net total effects of financing with a minus sign or parentheses when the amount is a net outflow. Round the interest expense to the nearest whole dollar.) Big Sky Adventures Ltd. Cash Budget February and March More info February March 16,200 Beginning cash balance Cash collections 0 Big Sky Adventures eliminates any cash deficiency by borrowing the exact amount needed from Caisse Populaire, where the current interest rate is 7%. Big Sky Adventures pays interest on its outstanding debt at the end of each month. The company also repays all borrowed amounts at the end of the month as cash becomes available. Cash from sale of plant assets 106,400 Cash available Cash payments: Purchases of inventory 47,800 Print Done Operating expenses 98,500 Total payments (1) Ending cash balance before financing 21,000 Minimum cash balance desired Cash excess (deficiency) Financing of cash deficiency $ $ 80,200 2,600 41,900 23,600 21,000
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
3
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
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
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education