The company wants to have a minimum of 50000 cash balance

Assignment Help Financial Accounting

Reference no: EM13371345

The company wants to have a minimum of $50,000 cash balance at the end of each quarter.

Assume cash is borrowed at the beginning of a quarter and repaid at the end of a quarter. Simple Interest is based on 1% each month on outstanding borrowings. Beginning cash balance is $60,000. Cash borrowed is assumed to happen on the first day of a quarter and any payments are assumed to occur on the last day of a quarter. Interest is only paid on cash repayments.

	Quarter 1	Quarter 2	Quarter 3	Quarter 4	Total Year
Cash Balance - Beginning	60,000
Total Cash Available	450,000	563,000	858,000	937,000	2,809,600
Total Cash Disbursements	460,000	563,000	739,000	760,000	2,522,000
Cash Flow - Excess (deficiency)
Financing:
Borrowings - Line of credit
Repayments - Line of Credit
Interest Paid - Line of Credit
Total Financing

Cash Balance - Ending

Monthly Interest Rate	1.00%

Reference no: EM13371345

Questions Cloud

1 write a method to calculate the area of a circle return : 1. write a method to calculate the area of a circle. return the area. also write how this method would be called in

1 a researcher studying the effects of environment on mood : 1. a researcher studying the effects of environment on mood asks participants to sit alone in a waiting room for 15nbsp

Marketing solution for your selected organizationuse a : marketing solution for your selected organizationuse a problem-solving model to address your chosen organizations

International tradewrite a 4-6 page essay evaluating the : international tradewrite a 4-6 page essay evaluating the role of governments in assuring that developing countries

The company wants to have a minimum of 50000 cash balance : the company wants to have a minimum of 50000 cash balance at the end of each quarter.assume cash is borrowed at the

1 ifnbspphi-z0 nbspalpha2 z0 assume alpha lt012 a company : 1. ifnbspphi-z0 nbspalpha2 z0 ? assume alpha lt0.1.2. a company produces cooling tubes. the pressure of the tube is an

The completion of this assignment will entail the design of : the completion of this assignment will entail the design of the structural fire protection for a simple warehouse

Dhl and fedex have helped companies throughout the world : dhl and fedex have helped companies throughout the world succeed in the global economy by understanding the customers

Q1 case studyon the advice of some of its wealthiest alumni : q1 case studyon the advice of some of its wealthiest alumni clare college has borrowed pound15m on a 40-year inflation-

User Account

All Pages