Questions Uploads

net

Question

I need detailed instructions for setting up excel to calculate present value, future value, and net present

value.  I have never used excel for any computations, so please don’t assume that I know any associated terminology.  You cannot insult me by being specific!

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"

e future value

Question

I need help calculating the following 2 questions. providing the steps on how you got to the answer will help me a

great deal.

Question 1. Calculate the future value given the following information: present value = $500; number of periods = 4; interest rate of 5%.

Question 2. 

Calculate the degree of operating leverage given the following information: sales of $25,000; variable costs of $13,000; and operating income of $7,000 for year one, and sales of $40,000; variable costs of $15,000; and operating income of $16,000 for year 2. Your answer should be rounded to two decimal places. (For this problem, specifically calculate the difference between the sales and the operating income for each of the given years. This will allow you to calculate the degree of operating leverage.)

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"

sales

Question

Assume the following information for the month of August.  June sales = $40,000; July sales = $65,000; August

sales = $52,850.  All sales are on an account and are collected as follows: 20% in the current month, 50% in the month following, 25% in the second month following, and 5% uncollectible.  The beginning cash balance is $14,670, with cash payments of $24,653.  If the minimum cash balance is $40,000, what is the amount needed by the bank, or how much is available to pay towards the bank loan? Show the amount needed as a positive number, and the amount to repay a loan as a negative number.

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"

credit

Question

1. ABC Company pays for merchandise entirely on credit as follows: 60% in the current month, 35% in the month

following, and 5% in the second month following. Assume January purchases are $65,000. How much of January purchases are paid for January?

2. ABC Company has sales forecasts of the following: February = $40,000; March = $65,000. All sales are on account and are collected as follows: 20% in the current month, 50% in the month following, 25% in the second month following, and 5% uncollectible. If the total cash receipts for March equal $48,250, what is the sales forecast for January?

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"