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 (g) 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.
Attachment:- Data.rar