Business investment class

Cerrado Publicado Mar 27, 2011 Pagado a la entrega
Cerrado Pagado a la entrega

I need the following assignment done by tomorow for $5. Thank you..

Financial Assignment 3

Chapter 6

This financial assignment has the weight of 25 points. Specific information regarding the assignment is listed below.

Total Points: 25 points

How to Submit: Save your work in either a Word or an Excel file and send it to me as an attachment in an email message. You do not have to restate the question; just enter the question numbers and your answers.

Part 1 – 8 points

Sam’s Appliance has just completed the first year of operation for his business and has the following information: sales, $200,000; cost of goods sold, $140,000; rent, $18,000; utilities, $8,400; insurance, $2,000; depreciation on equipment, $3,500; and interest, $10,000. Your forecast indicates that your sales will increase by 20%. Your rental agreement provides for a 3 increase percent per year. Sam has just read an article indicating that utility costs in his area will increase by 10% next year. Also, Sam just received a notice from his insurance company stating that his quarterly premium will increase to $600 beginning the first quarter of next year. The depreciation expense on the equipment will not change; however, Sam’s loan amortization schedule indicates that interest expense next year will be $9,000.

1. Using this data, construct an actual income statement for this year (1st year of operation) and a pro forma income statement for next year.

2. By what percentage did Sam’s net income change?

3. What is the current profit margin and the pro forma profit margin?

Part II – 8 points

Rosemary’s Music Store has projected sales for the next 3 months as follows: January, $15,000; February, $20,000; and March, $25,000. Based on last year’s data, cash sales are 20% of total sales for each month. Of the accounts receivable, 60% are collected in the month after the sale, and 40% are collected in the second month following the sale. Sales for November and December of the current year are $15,000 and $17,000 respectively. You have the following estimated payments: January, $4,500; February, $5,500; and March, $5,200.

4. Using the format from the pro forma cash budget shown in Table 6-8 on page 177 of your text, prepare a pro forma monthly cash budget for January, February, and March.

5. What is the balance in accounts receivable for the beginning of April?

6. Will Rosemary’s Music Store have any borrowing requirements for any month during this 3 month period?

Part III – 9 points

7. Create a pro forma balance sheet using the percentage of sales method based on the balance sheet provided below. The total sales for the current year are $275,000; the forecasted sales for next year are $350,000.

8. If net income is $50,000 next year, how much did the owners take out of the business?

9. What is required in new financing if next year’s sales forecast increases to $400,000, profit margin is 10%, and the payout ratio is 90 percent?

BALANCE SHEET

Assets

Current Assets:

Cash $5,694

Accounts Receivable 19,662

Inventory 3,381

Total Current Assets 28,737

Fixed Assets:

Furniture 5,595

Equipment 25,456

Total Fixed Assets 31,051

Total Assets $59,788

Liabilities & Owner's Equity

Current Liabilities

Accounts Payable $15,456

Accrued Taxes Payable 3,598

Total Current Liabilities 19,054

Long-Term Debt 18,654

Total Liabilities 37,708

Owner's Equity 22,080

Total Liabilities & Owner's Equity $59,788

Contabilidad Análisis de negocios Planes de negocios Finanzas

Nº del proyecto: #1001018

Sobre el proyecto

18 propuestas Proyecto remoto Activo May 2, 2011

18 freelancers están ofertando un promedio de $260 por este trabajo

dmjuma

I am certain I can do this for you. Check PM for more details.

$399 USD en 2 días
(41 comentarios)
5.5
derrick01

I can get it done

$250 USD en 1 día
(0 comentarios)
1.3
Tiwana1989

Hi, I am ACCA finalist with 2.5 years experience and can do this easily. But I don't understand why is 250 $ you are paying for this assignment. And also not found your email and what about 5 $. Can't understand your d Más

$250 USD en 1 día
(0 comentarios)
0.0
JayasingheT

I do this best

$250 USD en 1 día
(0 comentarios)
0.0
Ummeed

HI! You consider this assignment as done. Please check PM.

$251 USD en 0 días
(0 comentarios)
0.0
daisies1062

I can do this assignment, I bid$20 for the project and must be deposit in my GAF account immediately upon acceptance.

$250 USD en 2 días
(0 comentarios)
0.0
Suba1985

Dear Sir, I am Chartered Accountancy Strategic Level I student with two years audit firm experience and one year mercantile experience. So I can do this project very easily. Please give me this project.

$250 USD en 1 día
(0 comentarios)
0.0
RISHIKAJAIN27

Sir, i'm a Chartered Accountant and can complete this assignment before time. Thanks

$250 USD en 1 día
(0 comentarios)
0.0
JahanzaibAlam

You may not find many reviews for me as i have recently joined freelance. But this is a fairly simple question and i will be able to do it asap once i recieve your confirmation. I am an ACCA Affiliate and CFA Level Más

$250 USD en 0 días
(0 comentarios)
0.0
abdullah21

plz check my pm

$250 USD en 1 día
(0 comentarios)
0.0
jass18

Hello Please check PMB. Thanks for your time Regards Jass18

$275 USD en 1 día
(0 comentarios)
0.0
itsrajen

Please refer to my PM

$250 USD en 3 días
(0 comentarios)
2.4
Alifas

iam currently working in the capacity of a financial advisor at one of the big four professional services firm . iam new here on freelancer, i can surely work on all the areas you have highlighted as i have dealt with Más

$250 USD en 1 día
(0 comentarios)
0.0
sarahburnham

Run own bookkeeping business

$251 USD en 1 día
(0 comentarios)
0.0
freehaiqbal

hi, I can do it, I can provide you more than what you hope for.

$250 USD en 2 días
(0 comentarios)
0.0
srushtimody

Hi Please check PMB for additional details Regards

$250 USD en 1 día
(0 comentarios)
0.0