FIN 615 Financial Analysis and Modeling

PART 1

What is the formula on cell B5 that will allow you to calculate Total Current Assets/Total Current Liabilities?
a. =SUM(B1:B3)/B4
b. =(B1+B2+B3)/B3
c. =B1+B2+B3/B4
d. =SUM(B1:B3)/3
e. =SUM(B1:B4)/B4
What is the formula on cell B4 that will allow you to calculate the compound annual stock return from 2004 to 2008?
a. =(E2/A2^1/4)-1
b. =E3/A3^1/4-1
c. =(E3/A3)^(1/4)-1
d. =(E3/(A3^1/4))-1
e. =(E3/A3)^(1/4)+1
What solution would you get in cell A4?
a. 17.541
b. -4782.9
c. 2582.5
d. -2163.6
e. -5385.3
What custom category was used to format cell A2 using the data on cell A1?
a. #,##0.00,
b. #,##0.00
c. #,###.00
d. #,##0,
e. #,##0
What is the value of cell A4?
a. 20
b. 33
c. 18
d. 35
e. 13

To access towards the answers towards the above questions email : help@assingmentstore.com or chat with us live.

Submit Assignment

Fill in the form below or give us a call and we'll contact you. We endeavour to answer all enquiries within 24-48 hours on business days.
[contact-form-7 id="7458"]