Using only the information provided in the following worksheet, what is the correct formula to calculate the total cash flows from financing?

/in /by

1. Using only the information provided in the following worksheet, what is the correct formula to calculate the total cash flows from financing?
a. =(B2-C2)-(B4+(B3-C3))
b. =(B2-C2)+(B4-(B3-C3))
c. =(B3-C3)-(B4-(B2-C2))
d. =(B2-C2)-(B4-(B3-C3))
e. =(B2+C2)-(B4+(B3+C3))

2. What is the correct formula to calculate the percentage change in prepaid expenses from 2010 to 2011 using
horizontal analysis with percentages as solution?
A

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

B

C

D

Account

2011

2010

$ 10,000

$ 26,000

2 Accounts Receivable

49,600

35,460

3 Inventory

25,000

25,450

4 Prepaid Expenses

22,400

32,400

5 Notes Payable

52,000

52,000

6 Common Stock

34,000

45,000

7 Retained Earnings

21,000

22,310

1 Cash

a. (C4/D4)/2
b. C4/D4
c. C4*D4/2
d. (C4-D4)/D4
e. (D4-D5)/D5

(Format as a percentage)
(Format as a percentage)
(Format as a percentage)
(Format as a percentage)
(Format as a percentage)

3. Assume that this data represents all of the assets, liabilities and capital of a company. What is the formula to
calculate the number in vertical analysis for Inventory for 2011?

The post Using only the information provided in the following worksheet, what is the correct formula to calculate the total cash flows from financing? appeared first on Infinitessays.org.