Question: Functions: DAYS360, SUM; Formulas: Multiply, Divide; Cell Referencing Some cells are merged. Using Excel to Calculate Weighted Average Number of Shares Outstanding Student Work Area

Functions: DAYS360, SUM; Formulas: Multiply, Divide; Cell Referencing

Some cells are merged.

Using Excel to Calculate Weighted Average Number of Shares Outstanding

Student Work Area

Required: Provide input into cells shaded in yellow in this template. Use cell references with a mathematical formula to the Problem area and work area as indicated. Use the SUM function to total amounts and the DAYS360 function to calculate months between dates.

PROBLEM

Franklin Corporation had common shares on January 1, 2024. during the year, shares were repurchased and additional shares were issued. Information concerning the common shares is presented here.

Calculate the weighted average number of shares for the year ended December 31, 2024.

Common shares outstanding, January 1, 2024

20,000

Shares repurchased, March 1

5,000

Shares issued, June 1

6,000

Year end date

December 31, 2024

Shares issued, September 30

10,000

Start Date

Shares Outstanding

Number of Months

Weighted Shares

January 1, 2024

March 1, 2024

June 1, 2024

September 30, 2024

Weighted average number of shares outstanding

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Function: SUM; Formula: Multiply, Subtract; Cell Referencing Some cells are merged. Using Excel to Prepare a Statement of Retained Earnings Student Work Area PROBLEM Required: Provide input into...

SUM; Formula: Subtract; Cell Referencing Some cells are merged. Using Excel to Post to the General Ledger Student Work Area PROBLEM Required: Provide input into cells shaded in yellow in this...

Function: SUM; Formula: Subtract; Cell Referencing Some cells are merged. Using Excel to Prepare a Statement of Retained Earnings Student Work Area PROBLEM Required: Provide input into cells shaded...

Answer with cell refenrence as shown in the excel. A A B D G || K L M N 1 Functions: DAYS360, SUM; Formulas: Multiply, Divide; Cell Referencing 5 3 Using Excel to Calculate Weighted Average Number of...

A A B D G || K L M N 1 Functions: DAYS360, SUM; Formulas: Multiply, Divide; Cell Referencing 5 3 Using Excel to Calculate Weighted Average Number of Shares Student Work Area 4 Outstanding Required:...

Function: SUM; Formula: Add, Subtract; Cell Referencing Some cells are merged. Using Excel to Calculate the Recognized Gain Using Property Transaction Rules Student Work Area Required: Provide input...

Function: SUM; Formula: Add, Divide, Subtract, Multiply; Cell Referencing Using Excel For Incremental Analysis for Elimination of a Product Line Student Work Area Required: Provide input into cells...

Function: SUM; Formula: Subtract, Multiply; Cell Referencing Some cells are merged. Using Excel to Calculate Payroll Student Work Area PROBLEM Required: Provide input into cells shaded in yellow in...

HELP ASAP Formulas: Subtract, Add, Multiply, Divide; Cell Referencing BE16.6 - Using Excel to Determine the Markup Percentage Student Work Area Using the Cost-Plus Markup Method Required: Provide...

Function: AVERAGE; Formula: Divide; Cell Referencing Some cells are merged. Using Excel to Assess Accounts Receivable Student Work AreaPROBLEM Required: Provide input into cells shaded in yellow in...

The Macaulay Corporation issues $181,500 face value of 10 percent semi-annual bonds. The bonds are dated July 1, Year 1. The principal amount is repayable on July 1, Year 11, or ten years later....

In an expeniment on zield of suyon beute (toms/acu) there cwere two levels o inrigation tneatiment, and thaee of Letilizen each combination of tneatment coas canried out in 5 replicante. the...

If the financial markets are strong form efficient, then b . only company insiders have an advantage in financial markets a . only the most talented analysts can determine the true value of a...

11.15 Management has stated that it will tolerate one stockout per year. The forecast of annual demand for a particular SKU is 100,000 units, and it is ordered in quantities of 10,000 units. The lead...

Engage everyone in the dialogue

1. Given your basic mental state, i.e. the state you often return to. Give this state a name that you recognize and that is easy to remember, such as irritability, frustration, joy, etc. Also give...

5. The next time a negative event occurs, or a negative memory occurs, think about how you need to perform to make this a success story.