Reference no: EM131218339
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
|
What is white-coat hyperglycemia
: What is white-coat hyperglycemia - Describe the role of insulin and glucagon in the regulation of plasma glucose.
|
|
Simply trade second-hand securities
: 'Secondary markets simply trade second-hand securities. The original issuer receives nothing in this process. Therefore, secondary markets play no role in the capital formation process.' Evaluate this statement
|
|
What it is and its importance in american politics
: You have to research the topic of Political Stumping and write a 1-page paper on it. Talk about what it is and its importance In American politics. You must use APA format and you can only use one online source. The remaining two must come from a ..
|
|
Determine the transmissibility of the force
: Motion Transmissibility. Determine the transmissibility of the force transferred to the ground relative to the input force, F(t), for the massspring-damper system in Figure 1.15 (d).
|
|
Describes the computations reported in the cells
: Retrieve the file CFM2A08P.XLS. Enter the label (words or acronym) in cell A14 which describes the computations reported in cells B14 and D14.
|
|
Voluntarily give up to get an extra pear
: Inez reports that an extra banana would increase her utility by two units and an extra pear would increase her utility by six units. What is her MRS of bananas for pears-that is, how many bananas would she voluntarily give up to get an extra pear?
|
|
How company could improve the outcome of its campaign
: Share your own assessment as to how effective you believe the efforts is and how you believe the company could improve the outcome of its campaign. The paper should be 5 pages long. No bullet-point list allowed
|
|
Do you agree or disagree with the general point of view
: Support your discussion with at least 2 different sources (links) of information.- Do you agree or disagree with the general point of view?
|
|
Benefit of going to disneyland
: You visit the Disneyland from time to time. What is the opportunity cost of going to Disneyland? How about the benefit? Think about ways to measure your benefit of going to Disneyland.
|