What is the ending cash balance for the year

Reference no: EM131974131

Problem

Santa Monica, Inc. is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows:

	1^st Quarter	2^nd Quarter	3^rd Quarter	4^th Quarter
Total cash receipts	$500,000	$520,000	$480,000	$900,000
Total cash disbursements	$530,000	$600,000	$480,000	$520,000

The company's beginning cash balance for the upcoming fiscal year will be $100,000. The company requires a minimum cash balance of $50,000 at the end of each quarter and may borrow any amount needed form a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. The company's policy is to take any cash above $50,000 and pay off whatever portion of its loans that it can. Interest payments are due on any principal at the time it is repaid.

Required:

Prepare the company's cash budget for the upcoming fiscal year using the template on the following page. Then, answer the following questions:

What is the ending cash balance for the year?

How much money was borrowed during the year?

How much interest was paid during the year?

The company has an opportunity to get a lower interest rate of 2.00%. If they did so, however, they would have to maintain a minimum cash balance of $100,000 at the end of each quarter. Should they do this?

Reference no: EM131974131

Questions Cloud

Find what was cost of goods manufactured : Assume the only inventory balance is an ending Finished Goods Inventory balance of $9,100. What was cost of goods manufactured?

What is the sherman act : What is the Sherman Act? Why did it come into being? What kind of joint and unilateral activities are illegal according to the Sherman Act? Give three examples

Prepare entries that the seller should record for the sale : Santa Fe Company purchased merchandise for resale from Mesa Company with an invoice price. Prepare entries that the seller should record for the sale.

Adani carmichael coal mine project in queensland : Provide an example of positive analysis (including the reference), as well as normative analysis, relating to the project

What is the ending cash balance for the year : What is the ending cash balance for the year? How much money was borrowed during the year? How much interest was paid during the year?

Adani carmichael coal mine in queensland : Discuss the possible negative externalities associated with the project and how this would affect the efficient level of output. Depict this on a diagram.

What is the equilibrium if each player chooses : In the game of Chicken what is the equilibrium if each player chooses sequentially as in Stackelberg?

Why a government may not want to encourage competition : Why a government may not want to encourage competition in a market with a monopoly?

Complete the income statements using absorption costing : Complete the following income statements using absorption costing. Complete the following income statements using variable costing.

User Account

All Pages