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

Om arbejdsgiveren:
( 12 bedømmelser ) Arlington, United States

Projekt ID: #1001018

18 freelancere byder i gennemsnit \$260 på dette job

dmjuma

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

\$399 USD in 2 dage
(41 bedømmelser)
5.5
derrick01

I can get it done

\$250 USD på 1 dag
(0 bedømmelser)
1.3
jando

hi sir i have done my [url removed, login to view] with final account specialist and know how to analysis the statement plz. give me the chance i can do this work easily

\$250 USD in 4 dage
(0 bedømmelser)
0.0
freehaiqbal

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

\$250 USD in 2 dage
(0 bedømmelser)
0.0
sarahburnham

\$251 USD på 1 dag
(0 bedømmelser)
0.0
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 Flere

\$250 USD på 1 dag
(0 bedømmelser)
0.0
itsrajen

\$250 USD in 3 dage
(0 bedømmelser)
2.4
jass18

\$275 USD på 1 dag
(0 bedømmelser)
0.0
abdullah21

plz check my pm

\$250 USD på 1 dag
(0 bedømmelser)
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 Flere

\$250 USD in 0 dage
(0 bedømmelser)
0.0
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 Flere

\$250 USD på 1 dag
(0 bedømmelser)
0.0
cjthomas

Hello, I can do your financial assignment ASAP and deliver the same tomorrow. All terms can be discussed at the time of [url removed, login to view] see the PM. Regards

\$250 USD på 1 dag
(1 bedømmelse)
0.0
RISHIKAJAIN27

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

\$250 USD på 1 dag
(0 bedømmelser)
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 på 1 dag
(0 bedømmelser)
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 in 2 dage
(0 bedømmelser)
0.0
Ummeed

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

\$251 USD in 0 dage
(0 bedømmelser)
0.0
JayasingheT

I do this best

\$250 USD på 1 dag
(0 bedømmelser)
0.0
srushtimody