How to prepare a monthly schedule of cash receipts

Assignment Help Financial Management
Reference no: EM13215793

1) Please answer the following question. For Part A of the question I suggest you look at examples in the electronic textbook to determine how to prepare the schedule.

Ellis Sport Shop projects the following sales:

April - $75,000
May - $95,000
June - $100,000

Seventy percent of Ellis' sales are on credit with 60 percent of receivables collected in the month after the sale and the rest of receivables collected in the second month after the sale. February sales were $60,000 and March sales were $70,000. In the past Ellis' bad debt percentage has been 0 and is expected to continue.

a) Prepare a monthly schedule of cash receipts for April-June.

b) What is the balance of Receivables at the end of June?

2)Ohlin, Meade, and Assoc. plans to borrow $1,500,000 for 12 months. Citibank gives the firm a stated rate of 10 percent interest.
What is the effective rate of interest if the loan carries a simple 10 percent interest with a 20 percent compensating balance?

3) I suggest you look at examples in the electronic textbook and the problems assigned to determine how to rank each alternative.
A&B Enterprises is trying to select the best investment from among four alternatives. Each alternative involves an initial outlay of $100,000. Their cash flows follow:

Evaluate and rank each alternative based on a) payback period, and b) net present value (use a 10% discount rate).

Reference no: EM13215793

Questions Cloud

Study on the effects of activated carbon : Parametric study on the effects of activated carbon by calcium chloride activation from bark of calamansi tree on sewage wastewater treatment.
Explai preferred stock is cumulative and fully participating : Assuming that the directors decide to declare total dividends in the amount of $382,508, determine how much each class of stock should receive under each of the conditions stated below. One year's dividends are in arrears on the preferred stock.
Example of z-test to test the null hypothesis : Prepare a 2 slide Microsoft PowerPoint Presentation with speaker notes, how to use a z-test to test the null hypothesis and give an example of z-test to test the null hypothesis
Estimate the proportion of defective parts : The production manager wants to estimate the proportion of defective parts received from this supplier. She believes the proportion defective is no more than 0.15 and wants to be within 0.04 of the true proportion of defective parts with a 90% lev..
How to prepare a monthly schedule of cash receipts : Seventy percent of Ellis' sales are on credit with 60 percent of receivables collected in the month after the sale and the rest of receivables collected in the second month after the sale.
Explain the preferred stock is cumulative and participating : Assuming that the company has retained earnings of $85,000, all of which is to be paid out in dividends, and that preferred dividends were not paid during the 2 years preceding the current year, state how much each class of stock should receive.
Explain what was the original annual rate of return : What was the original annual rate of return needed to reach your goal when you started the fund two years ago? With only $140,000 in the fund and 10 years remaining until your first child starts college, what annual rate of return would the fund ha..
What are the warranty expense balances for 2014 and 2015 : Merritt Equipment Company sells computers for $1,790 each and also gives each customer a 2-year warranty that requires the company to perform periodic services and to replace defective parts. During 2014, the company sold 850 computers.
Long-term and any-occupation disability policy available : Deshawn Carter has just received his open-enrollment notification and has asked you to assess his disability insurance coverage. He currently has a long-term, any-occupation disability policy available through his employer that pays a benefit of 8..

Reviews

Write a Review

Financial Management Questions & Answers

  Financing a new project with new equity will reduce earnings

During recent years your company has made considerable use of debt ?nancing, to the extent that it is generally agreed that the percent debt in the ?rm's capital structure is too high.

  Exotic cuisines employee stock options

What happens is that a company experiences a stock price decrease, which leaves employee stock options farout of the money or underwater and what are the implications for employee stock options? In light of your answer, can yourecommend an improvem..

  Analysis of the investment

In this project, you will focus on one of these: the additional cost resulting from the purchase of an apple press (a piece of equipment required to manufacture apple juice).

  Forecasting interest rates based on prevailing conditions

Forecasting Interest Rates Based on Prevailing Conditions - discuss the impact of each of the factors on your opinion. Offer some logic or current reference(s) to support your answer. Which factor do you think will have the biggest impact on intere..

  Explain manage potential conflicts of interest

Financial Analysis (called Security Analysis on Wall Street) can be less than totally objective. How big a problem do you think this is? What can be done to manage potential conflicts of interest? Maybe we just have to live with it and search out ..

  Hardware and software manufacturing to china or india

The firm manufactures a global positioning system (GPS) that sells for $2,000, with cost of goods sold (hardware 30% and software 70%) of 55% of sales.

  Compute the cost of equity financing

This assignment shows how to Compute the cost of equity financing and aslo Compute the Weighted Average Cost of Capital.

  Evaluate the performance of a company

Evaluate the performance of a company using various financial analytical tools and analyse different patterns of cost behaviour and apply cost-volume-profit analysis to business decisions.

  Investment in a commercial property

To tap into the above market, you have already entered into a sizeable investment in a commercial property. The currency of Denmark is Danish Kroner, or Krone, and we use DKK for it below.

  Report on a company providing a clear audit trail

Prepare report on providing a clear audit trail to your company.  Prepare a portfolio of analytical reference materials including the financial reports for at least five years. This is your analytical permanent file for the chosen company.

  What is the expected return on the market

What is the expected return on the market and What is the risk-free rate?

  Impact short-run inflation and output byaltering

Given a firms liabilities an increase in interest rates reduces thefirm's net worth because - difficult to keep inflation and output fromfluctuating when aggregate expenditures change because

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