Project #13490 - Eastland Products, Inc. Amexicorp, Inc.

 

PRINCIPLES OF FINANCIAL ANALYSIS

 

 

 

SPREADSHEET ASSIGNMENT: Eastland Products, Inc.

 

                        Amexicorp, Inc.

 

 

 

 

 

1. Retrieve the file CFM0318P.XLS.  Boldface cell A1 and enter the

 

   appropriate values in cells C7 and C17.

 

 

 

2. Enter the appropriate equations, not values, into the following

 

   cells: C20, C29, C45, C46, C47, C48, C49, D9, and D16.

 

 

 

3. Print the worksheet.

 

 

 

4. Disregard the information presented in part (f) of the

 

   Eastland problem and restore the original balance sheet values.

 

   Construct a new balance sheet assuming 2 million common shares

 

   were sold to net $25 per share, with the proceeds allocated as

 

   follows: $25 million is used to discharge current liabilities,

 

   and $25 million is added to liquid assets.  Modify cells C52,

 

   C53, C54, and C55.

 

 

 

5. Print the worksheet.

 

 

 

6. Retrieve the file CFM2A08P.XLS.  Enter the label (words or

 

   acronym) in cell A14 which describes the computations reported

 

   in cells B14 and D14.

 

 

 

7. Enter the appropriate values in the following cells: B16, D16,

 

   B18, and D18.

 

 

 

8. Enter the appropriate equations, not values, into the following

 

   cells: B20, D21, B22 (assume a tax rate of 35%), and D27.

 

 

 

9. Print the worksheet.

 

 

 

 

 

Do not print equations or the contents of each cell.  The pages you submit should report final results, revealing the business output (such as dollar values) of a financial statement.

 

 

 

Pages must be assembled in proper sequence and be stapled or clipped together.

 

 

 

Subject Business
Due By (Pacific Time) 09/30/2013 08:00 am
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy