5 Position Type 6 Executives 7 Managers 8 Professionals 9 Interim 10 Total 11 12 Percentage per Month 13 Share 14 15 16 Monthly Dividend 17 Amount 18 Net Amount Net Dividend % (After 19 Deductions) 20 21 22 Position Type 23 Executives 24 Managers 25 Professionals 26 Interim 27 Total 28 29 30 Monthly Dividend 31 Amount 32 Net Amount Net Dividend % (After 33 Deductions) 34 35 Net dividends 35% + 27% January $ 98,348 50 $ 74,474.35 $ 31,330 21 $ 18,307.52 $ 222,460.58 $ $ $ $ $ $ $ $ January July 62% 98,000 $ 78,500 $ 31,000 $ $ 22,000 $ 229,500 $ Documentation July 8,032 50 $ 4,980.15 $ 62% February 89532.9 65742.12 29667.74 April 75279.26 52540.58 27274.09 15002 26 15721.80654 12382 1 199945.02 182459.6465 167476.03 February $ August 89,000 $ 65,000 $ 29,000 $ 15,000 $ 198,000 $ August 5,346.00 $ 3,314 52 $ Sales D E Monthly sales March 81522.67 56330.69 28884.48 Dividends Paid April March $ Estimated Sales October September 90,000 $ 70,000 $ 30,000 $ 16,000 $ 206,000 $ September Estimated Dividends 7,210.00 $ 4,470 20 $ $ 92,000 $ 72,000 $ 31,000 $ 18,000 $ 213,000 $ October 7,455.00 $ 4,622 10 5 F May 91610 24 68080.67 27281.96 20009 22 206982.09 May November 94,000 $ 74,000 $ 33,000 $ 19,500 $ 220,500 $ June 97352.68 78107.76 30099.43 21272 37 226832.24 June December 91,500 $ 71,000 $ 30,000 $ 19,000 $ 211,500 $ November December 7,717 50 $ 7,402.50 4,784.85 $ 4,589.55 H Trend Trend Total 554,500 430,500 184,000 109,500 1,278,500 Trend S 5 Total 533,646 25 S $ Total Avg. Placements Estimates only 43 20 22 28 Total 43,163.50 26,761.37 M
5 Position Type 6 Executives 7 Managers 8 Professionals 9 Interim 10 Total 11 12 Percentage per Month 13 Share 14 15 16 Monthly Dividend 17 Amount 18 Net Amount Net Dividend % (After 19 Deductions) 20 21 22 Position Type 23 Executives 24 Managers 25 Professionals 26 Interim 27 Total 28 29 30 Monthly Dividend 31 Amount 32 Net Amount Net Dividend % (After 33 Deductions) 34 35 Net dividends 35% + 27% January $ 98,348 50 $ 74,474.35 $ 31,330 21 $ 18,307.52 $ 222,460.58 $ $ $ $ $ $ $ $ January July 62% 98,000 $ 78,500 $ 31,000 $ $ 22,000 $ 229,500 $ Documentation July 8,032 50 $ 4,980.15 $ 62% February 89532.9 65742.12 29667.74 April 75279.26 52540.58 27274.09 15002 26 15721.80654 12382 1 199945.02 182459.6465 167476.03 February $ August 89,000 $ 65,000 $ 29,000 $ 15,000 $ 198,000 $ August 5,346.00 $ 3,314 52 $ Sales D E Monthly sales March 81522.67 56330.69 28884.48 Dividends Paid April March $ Estimated Sales October September 90,000 $ 70,000 $ 30,000 $ 16,000 $ 206,000 $ September Estimated Dividends 7,210.00 $ 4,470 20 $ $ 92,000 $ 72,000 $ 31,000 $ 18,000 $ 213,000 $ October 7,455.00 $ 4,622 10 5 F May 91610 24 68080.67 27281.96 20009 22 206982.09 May November 94,000 $ 74,000 $ 33,000 $ 19,500 $ 220,500 $ June 97352.68 78107.76 30099.43 21272 37 226832.24 June December 91,500 $ 71,000 $ 30,000 $ 19,000 $ 211,500 $ November December 7,717 50 $ 7,402.50 4,784.85 $ 4,589.55 H Trend Trend Total 554,500 430,500 184,000 109,500 1,278,500 Trend S 5 Total 533,646 25 S $ Total Avg. Placements Estimates only 43 20 22 28 Total 43,163.50 26,761.37 M
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Related questions
Question
I need help to do questions 8, 9, and 11 for the Excel Worksheet. Also, please make sure that you provide the steps carefully and get to understand the work as possible. Those questions that I will provide you would be from Microsoft Word.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education