Loading...

Messages

Proposals

Stuck in your homework and missing deadline?

Get Urgent Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework Writing

100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

1. Use the numbers given to complete the cash budget and short-term financial plan.

Category: Accounting & Finance Paper Type: Online Exam | Quiz | Test Reference: N/A Words: 826

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.

 

 

Our Top Online Essay Writers.

Discuss your homework for free! Start chat

Top Rated Expert

ONLINE

Top Rated Expert

1869 Orders Completed

ECFX Market

ONLINE

Ecfx Market

63 Orders Completed

Assignments Hut

ONLINE

Assignments Hut

1428 Orders Completed