Reference no: EM131297401
This assignment will require you to prepare the cash budget and determine the cash surplus and shortage each month.
The management estimates total sales for the period January through July based on actual sales from the immediate past quarter. The following assumptions are made:
Sales: Past and Expected
Historical Forecast
October $300,000 January $150,000
November $350,000 February $200,000
December $400,000 March $200,000
April $300,000
May $250,000
June $200,000
July $300,000
a. 25% of the Sales will be collected in the same month of the Sale. 60% of the Sales will be collected one month following the sale. 10% will be collected two months following the sale. The remainder will be collected three months following the sale. Bad debts are insignificant.
b. Purchases are 80% of sales and are paid in the same month.
c. Wages and salaries are as follows:
January $30,000
February $40,000
March $50,000
April $50,000
May $40,000
June $35,000
Wages and salaries are paid in the same month.
d. Rent is $10,000 per month. Rent is paid in the same month.
e. The company issued $500,000 bonds, paying annual coupon rate of 5%. Interest on these bonds is paid at the end of each calendar quarter. Hint: Firsts, calculate the coupon interest amount for each quarter. Then, this quarterly interest amount will be paid at the end of each calendar quarter.
f. A tax prepayment of $75,000 is paid in April.
g. Machinery worth $35,000 will be purchased in March.
h. Cash on hand on January 1st will amount to $100,000 and a minimum cash balance of $100,000 each month will be maintained throughout the period.
1. Prepare cash budget from January to June.
2. Determine the cash surplus and shortages for each month from January to June.
|
Two years of mortgage the borrower makes monthly payments
: A mortgage broker is offering a $174,900 25-year mortgage with a teaser rate. In the first two years of the mortgage, the borrower makes monthly payments on only a 3.1 percent APR interest rate. After the second year, the mortgage interest rate charg..
|
|
Bond yields and rates of return
: Bond Yields and Rates of Return A 25-year, 8% semiannual coupon bond with a par value of $1,000 may be called in 4 years at a call price of $1,100. The bond sells for $950. (Assume that the bond has just been issued.) What is the bond's yield to matu..
|
|
The mortgage interest rate charged increases
: A mortgage broker is offering a $280,000 25-year mortgage with a teaser rate. In the first two years of the mortgage, the borrower makes monthly payments on only a 4.6 percent APR interest rate. After the second year, the mortgage interest rate charg..
|
|
Yield to maturity and current yield
: Bond Yields Problem 4-13 Yield to Maturity and Current Yield You just purchased a bond that matures in 5 years. The bond has a face value of $1,000 and has an 8% annual coupon. The bond has a current yield of 8.21%. What is the bond's yield to maturi..
|
|
Determine cash surplus and shortages for each month
: This assignment will require you to prepare the cash budget and determine the cash surplus and shortage each month. The management estimates total sales for the period January through July based on actual sales from the immediate past quarter. Determ..
|
|
Discuss the financial statements the jobs act requires
: What is the market value of a standard interest rate swap when it is created and why does the market value of the swap change over time? Identify two financial intermediaries? What are there functions? What are their major roles in the economy? Discu..
|
|
What was the net income of company
: A company paid out $30 million in dividends and reported $300 million of retained earnings in 2015. The retained earnings in 2014 was $230 million. What was the net income of this company in 2015? $120 million $100 million $75 million $118 million No..
|
|
Differences between interest rate swap and interest rate cap
: What are the differences between an interest rate swap and an interest rate cap? What factors determine the premium (price) for an interest rate cap?
|
|
Use interest rate swap to create net fixed rate on the debt
: Stagecoaches, Inc. has $100,000,000 in 5-year floating rate debt with an interest rate of LIBOR + 3.0% and quarterly payments. Describe how the firm can use an interest rate swap to create a net fixed rate on the debt. Given the current fixed-rate on..
|