Answered step by step
Verified Expert Solution
Question
1 Approved Answer
ABC Bhd provides the following information in respect of its 3-month cash budget for the year 2019 as shown in the table below. ABC Bhd
ABC Bhd provides the following information in respect of its 3-month cash budget for the year 2019 as shown in the table below.
- ABC Bhd currently has a cash balance of RM40,000 and intends to maintain a minimum cash balance of RM20,000 each month.
- The company can borrow at the beginning of the month in which the funds are needed to maintain the minimum cash balance and the interest on loan is 24% per year. The interest on outstanding loan is paid in the month that follows the month in which the loan is obtained.
- You are required to complete the 3-month (October, November, and December) cash budget table for ABC company. Note: Provide answers ONLY for coloured boxes A to N
| Month | October | November | December |
1 | Beginning cash balance | RM40,000 | E | J |
2 | Net Change in cash for the period | (RM40,200) | RM8,604 | RM12,240 |
3 | New financing needed | A | F | K |
4 | Interest on loan | B | G | L |
5 | Loan repayment | C | H | M |
6 | Ending cash balance | D | I | N |
7 | Minimum cash balance | (RM20,000) | (RM20,000) | (RM20,000) |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started