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

  Financial decision-making techniques

Complete a project that helps you apply theoretical knowledge of financial planning to practical applications. It is a proven fact that learning by doing is more effective than reading theory.

  Evaluate sharpe''s beta coefficient

Evaluate Sharpes Beta Coefficient,  Evaluate the Beta Coefficient for Stock X and Stock Y using both regression and the formula given in your text. Highlight your answers in red.

  Compute the payoff schedule for the call option

Compute the payoff schedule for the call option using the following stock prices, S, and draw a graph of the payoff schedule and Compute the payoff schedule for the call option using the following stock prices, S, and draw a graph of the payoff sched..

  Estimate the residual value and perform firm valuation

Estimate the Residual Value and perform the corresponding firm valuation.

  How would you advise the company to handle the repatriation

Determine the spot and 12-month forward exchange rates, and determine any change in the ROS repatriated in 12 months based on exchange rates versus the current forecast.

  Calculate payback period and internal rate of return (irr)

Company has an opportunity to make an investment with the estimated after tax cash flows

  Evaluate the value of leased assets

Estimate the value of leased assets. If you misestimate the average life to be 10 years, how large will the valuation error be?

  Negative growth stock

Questions related to Negative growth stock

  Explain conventional mortgage how big a monthly payment

Woukd it make any differences if they were already making monthly installment loando payments totaling $750 on two car loans?

  Prepare the business income statement for the period

Prepare the business Income Statement for the period. Prepare the Statement of Changes in Equity for the period. Prepare the classified Balance Sheet at the end of the period.

  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.

  What gives rise to the currency exposure at aifs

What gives rise to the currency exposure at AIFS and what would happen if Archer-Lock and Tabaczynski did not hedge at all?

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