Part 1:
|
Q1
|
Q2
|
Q3
|
Q4
|
sales
|
863500
|
918500
|
996000
|
924000
|
borrowing
|
_
|
_
|
_
|
225000
|
net receipt
|
863500
|
918500
|
996000
|
1149000
|
purchases
|
459250
|
498000
|
462000
|
454000
|
wages and other costs
|
259050
|
275550
|
298800
|
277200
|
interest expanse
|
115000
|
115000
|
115000
|
115000
|
short tern interest expense
|
_
|
_
|
_
|
3375
|
Net payment
|
833300
|
888550
|
875800
|
849575
|
total receipt
|
30200
|
29950
|
120200
|
299425
|
bank balance at start
|
154000
|
184200
|
214150
|
334350
|
bank balance at the end
|
184200
|
214150
|
334350
|
633775
|
Company has to maintain $100000 at the end of every quarter and for
purchasing machinery we need further $225000 for cover its short-term
loan and provide support to company.
2.
Rework the cash budget and short-term
financial plan assuming popcorn changes to a target balance of $80000.
Cash
budget:
|
Q1
|
Q2
|
Q3
|
Q4
|
Beginning
cash balance
|
154000
|
184200
|
214150
|
334350
|
Net
cash flow
|
30200
|
29950
|
120200
|
299425
|
Ending
cash balance
|
184200
|
214150
|
334350
|
633775
|
Minimum
cash balance
|
100000
|
100000
|
100000
|
100000
|
Cumulative
surplus(deficit)
|
84200
|
114150
|
234350
|
533775
|
Short term financial
plan:
|
Q1
|
Q2
|
Q3
|
Q4
|
Target
cash balance
|
154000
|
184200
|
214150
|
334350
|
Net
cash inflow
|
30200
|
29950
|
120200
|
299425
|
New
short-term investment
|
_
|
_
|
_
|
_
|
Income
from short term investment
|
_
|
_
|
_
|
_
|
Short
term investment sold
|
_
|
_
|
_
|
_
|
New
short-term borrowing
|
_
|
_
|
_
|
225000
|
Interest
on short term borrowing
|
_
|
_
|
_
|
(3375)
|
Short
term borrowing repaid
|
_
|
_
|
_
|
_
|
Ending
cash balance
|
184200
|
214150
|
334350
|
855400
|
Minimum
cash balance
|
100000
|
100000
|
100000
|
100000
|
Cumulative
surplus(deficit)
|
84200
|
114150
|
234350
|
755400
|
Beginning
short term investment
|
_
|
_
|
_
|
_
|
Ending
short term investment
|
_
|
_
|
_
|
_
|
Beginning
short term debt
|
_
|
_
|
_
|
225000
|
Ending
short term debt
|
_
|
_
|
_
|
221625
|
Part 2:
1.
You have looked at the credit policy
offered by your competitors and have determined that the industry standards
credit policy is1/10, net 45.this discount will begin to be offered on the
first day of the year. You want to examine how this credit policy would affect
the cash budget and short term financial plan. Of this credit policy is
implemented, you believe that 60 percent of customers will take advantage of
the credit offer and the accounts receivable period will be 24 days. Rework the
cash budget and short term financial plan under the new credit policy and a
target cash balance of $80000. What interest rate are you effectively offering
customers?
Ans.
according to this policy, if the industry’s customer returns in 45 days then
10% discount will be avail by all the customers. Companies apply this policy
and consider that almost 60% customers want to get benefit from this policy as
they required discounts on their term of credit. Because company want to
compete all their competitors and try to capture more and more customers.
|
Q1
|
Q2
|
Q3
|
Q4
|
Beginning
cash balance
|
154000
|
184200
|
214150
|
334350
|
Net
cash flow
|
30200
|
29950
|
120200
|
299425
|
Ending
cash balance
|
184200
|
214150
|
334350
|
633775
|
Minimum
cash balance
|
80000
|
80000
|
80000
|
80000
|
Cumulative
surplus(deficit)
|
104200
|
134150
|
254350
|
553775
|
Short term financial
plan:
|
Q1
|
Q2
|
Q3
|
Q4
|
Target
cash balance
|
154000
|
184200
|
214150
|
334350
|
Net
cash inflow
|
30200
|
29950
|
120200
|
299425
|
New
short term investment
|
_
|
_
|
_
|
_
|
Income
from short term investment
|
_
|
_
|
_
|
_
|
Short
term investment sold
|
_
|
_
|
_
|
_
|
New
short term borrowing
|
_
|
_
|
_
|
225000
|
Interest
on short term borrowing
|
_
|
_
|
_
|
(3375)
|
Short
term borrowing repaid
|
_
|
_
|
_
|
_
|
Ending
cash balance
|
184200
|
214150
|
334350
|
855400
|
Minimum
cash balance
|
80000
|
80000
|
80000
|
80000
|
Cumulative
surplus(deficit)
|
104200
|
134150
|
254350
|
775400
|
Beginning
short term investment
|
_
|
_
|
_
|
_
|
Ending
short term investment
|
_
|
_
|
_
|
_
|
Beginning
short term debt
|
_
|
_
|
_
|
225000
|
Ending
short term debt
|
_
|
_
|
_
|
221625
|
And with this we have to offer a interest rate
of more than 10% to all its customers during applicable of new credit
policy.
2.
You have talked to the company’s suppliers
about the credit terms piepkorn receives. Currently, the company receives terms
of net 45. Your suppliers have stated that they would offer new credit terms of
2/25, net 40. The discount would begin to be offered on the first day of the
year. What interest rate are the suppliers offering the company? Rework your
cash budget and short term financial plan from the previous question assuming
you take advantage of the discount offered.
Ans.
when new term of credit applies by the supplier then company avail the 2
percent interest if they paid in 25 days which is under the company’s credit
days and company try to meet this requirement and avail maximum advantage from
this opportunity. With this facility, the company also get proper discount
after getting the benefit from these policies. And company can safe more money
at the end of period and attain more savings from its suppliers.