Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
Create a cash budget for the first six months of 2000 used on the follow hond to their montre projected to be Sweet INCREASE ch
Create a cash budget for the first six months of 2000 used on the follow hond to their montre projected to be Sweet INCREASE ch month by 145.000 Conctions where to Collected within the Collected month were Uncollectable 15 EN 59 Export month we wted to be INCREASE eth month by Monthly depreciation included the who mu SOOD 2 51.000 This new combi 200 with a cash balance 25 000 The common woman cash balance (gel balance 550.000 The company would like to maintain the minimum cash balance, as stated above. How much would the company need to borrow if they want to maintain the minimum cash balance (target balance) each month? How much surplus would they have over the minimum cash balance each month? Don't assume they will borrow. We only want to Gilculate how much they would need to borrow, or how much of a surplus they would have each month) Prepare a monthly cash budget for the first six months of 2009. Calculate the loan requirement and surplus cash for each month of the six month cash budget using IF functions. (For each month of the cash budget, use a formula to calculate the loan requirement, and the surplus. The last two lines of the cash flow statement should be LOAN REQUIREMENT SURPLUS Place all of the assumptions at the top of the spreadsheet, and use them. (USE ABSOLUTES. THERE SHOULD BE NO NUMBERS TYPED IN ANY FORMULAS OR IN THE CASH BUDGET STATEMENT NUMBERS SHOULD BE TYPED IN THE ASSUMPTIONS AREA ONLY) Create a cash budget for the first six months of 2000 used on the follow hond to their montre projected to be Sweet INCREASE ch month by 145.000 Conctions where to Collected within the Collected month were Uncollectable 15 EN 59 Export month we wted to be INCREASE eth month by Monthly depreciation included the who mu SOOD 2 51.000 This new combi 200 with a cash balance 25 000 The common woman cash balance (gel balance 550.000 The company would like to maintain the minimum cash balance, as stated above. How much would the company need to borrow if they want to maintain the minimum cash balance (target balance) each month? How much surplus would they have over the minimum cash balance each month? Don't assume they will borrow. We only want to Gilculate how much they would need to borrow, or how much of a surplus they would have each month) Prepare a monthly cash budget for the first six months of 2009. Calculate the loan requirement and surplus cash for each month of the six month cash budget using IF functions. (For each month of the cash budget, use a formula to calculate the loan requirement, and the surplus. The last two lines of the cash flow statement should be LOAN REQUIREMENT SURPLUS Place all of the assumptions at the top of the spreadsheet, and use them. (USE ABSOLUTES. THERE SHOULD BE NO NUMBERS TYPED IN ANY FORMULAS OR IN THE CASH BUDGET STATEMENT NUMBERS SHOULD BE TYPED IN THE ASSUMPTIONS AREA ONLY)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/66914977a2e33_559669149773b075.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started