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

  Foreign company acquisition

Acquisition by a foreign company and the effects of that decision and the results of foreign exchange in Euro and the exchange rate differences.

  Financial management for profit and non profit organizations

In this essay, we are going to discuss the issues of financial management in a non-profit organisation.

  Method for estimating a venture''s value

Evaluate venture's present value, cash and surplus cash and basic venture capital.

  Replacement analysis

This document show the Replacement Analysis of modling machine. Is replacement give profit to company or not?

  Business finance task - capital budgeting

Your company is considering using the payback period for capital-budgeting. Discuss the advantages and disadvantages of this technique.

  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).

  Conduct a what-if analysis

Review the readings and media for this unit, including the Anthony's Orchard case study media. Familiarise yourself with the Anthony's Orchard company and its current situation.

  Determine operational expenditures

Organisations' behaviour is guided by financial data. In the short term, such data will help determine operational expenditures; in the long term, historical data may help generate forecasts aimed at determining strategic plans. In both instances.

  Personal financial management

How much will you have left over each half year if you adopt the latter course of action?

  Sources of finance for expansion into new foreign markets

A quoted company is considering several long-term sources of finance for expansion into new foreign markets.

  Long term financial planning

This assignment is designed for analyze Long term financial planning begins with the sales forecast and the key input in the long term fincial planning.

  Explain the role of fincial manager

This assignment explain the role of fincial manager, function of manger. And what are the motives of financial manager.

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