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-

Reviews

Write a Review

Financial Accounting Questions & Answers

  Calculation of cash break-even quantity and financial

calculation of cash break-even quantity and financial break-even quantity.in each of the following cases find the

  Describes limitations on the usefulness of the presentation

Describes limitations on the usefulness of the presentation. Provides an explanation of the differences between an examination and a review.

  What type of report you should issue and why

Explain how you should handle this situation- explain what type of report you should issue and why

  Illustrate what is the weakest point in this network

Illustrate what is the weakest point in this network on which forensic investigators should concentrate their efforts for determining whether money laundering is occurring?

  Prepare an income statement for the year ended

Prepare an income statement for the year ended December 31, 2011, and a balance sheet as of December 31, 2011 and prepare all journal entries to record the information for 2012. Also prepare any necessary adjusting entries.

  Distribution of income or loss to partnersjane invested

distribution of income or loss to partners.jane invested 100000 and paul invested 90000 in a new partnership. they

  Compute the unit sales to earn the target after-tax

Assume that fixed costs remain at $630,000. Compute the unit sales to earn the target after-tax net income and (2) dollar sales to earn the target after-tax net income.

  Illustrate what would ortiz report as total revenue

Illustrate what would Ortiz report as total revenue in a single-step income statement?

  Who also acts as chief executive officer

HS's board of directors is controlled by George Waltson, the majority shareholders, who also acts as the chief executive officer.

  Multiple choices on variance analysisthe following company

multiple choices on variance analysis.the following company information is availabledirect materials used for

  Journal entries for recording transactions

Journal entries for recording transactions of disposition and purchase of asset - Prepare the journal entries to record the transactions April1 and August 1, 2007.

  Calculate the ebit-eps indifference pointemco products has

calculate the ebit-eps indifference point.emco products has a present capital structure consisting only of common stock

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd