What is the return of this transaction? (Not sure whether to use Money weighted return or Time weighted return?) Round off to 2 decimal places. If possible, please show workings on excel for asap:)
What is the return of this transaction? (Not sure whether to use Money weighted return or Time weighted return?) Round off to 2 decimal places. If possible, please show workings on excel for asap:)
Dates | Transaction | Share Price |
1/1/18 | Bought 5000 shares | 40 |
1/9/18 | 42 | |
2/15/18 | 43 | |
3/8/18 | Bought 150 shares | 40 |
4/21/18 | Sold -600 shares | 57 |
6/30/18 | Received dividends of R2 per share | 44 |
12/31/18 | Bought 400 shares | 51 |
4/12/19 | Sold -500 shares | 41 |
6/30/19 | Received dividends of R2 per share | 49 |
7/5/19 | Sold -500 shares | 56 |
12/31/19 | Exited Trade | 52 |
Homework Answers
Request Answer!
We need at least 7 more requests to produce the answer.
3 / 10 have requested this problem solution
The more requests, the faster the answer.
Add Answer to:
What is the return of this transaction? (Not sure whether to use Money weighted return or Time weighted return?) Round off to 2 decimal places. If possible, please show workings on excel for asap:)
2. Prepare journal entries to record the following transactions involving both the short-term and long-term investments...
2. Prepare journal entries to record the following transactions involving both the short-term and long-term investments of HDX Inc., all of which occurred during calendar year 2019. a. On February 15, paid $100,000 cash to purchase Apex's 90-day short-term notes at par, which are dated February 15 and pay 5% interest (classified as short-term held-to- maturity). O B. On March 22, bought 1,000 shares of Fox Industries common stock (2% of Fox's outstanding stock) at $25 cash per share plus...
4 The following information is provided for the newly formed corporation, LAX, Inc. on January 1,...
4 The following information is provided for the newly formed corporation, LAX, Inc. on January 1, 2023: 5 Treasury Outstanding Authorized Issued Common stock, $1 par value: 100,000,000 35.000.000 34,510,000 Preferred stock, 6.5%, $100 par value: 1.000.000 500,000 Treasury stock, $42.35 basis: 490.000 10 11 1. On 3/31/23, LAX, Inc. issued 15,000,000 shares of of common stock in a seasoned offerring for $50.88 per share. Record the journal entry: 12 13 Date Accounts Debits Credits 14 15 2023/3/31 16 17...
Please show in excel like above, thanks! Balance Sheet & Income Statement Coast Ltd., which has...
Please show in excel like above,
thanks!
Balance Sheet & Income Statement Coast Ltd., which has just started trading on 1 January 2019. has the following account balances prior to the recording of the final month of the year: Account Balances as at 30 November 2019 Account $ Cash $5 300 Accounts receivable $6 400 Stock of Supplies $11 600 Property, Plant & Equipment -cost $36 000 Accounts payable $3 000 Interest payable S 100 Bank Loan $12 000 Contributed...
Amalgamated General Corporation is a consulting firm that also offers financial services through its credit division....
Amalgamated General Corporation is a consulting firm that also offers financial services through its credit division. From time to time the company buys and sells securities. The following selected transactions relate to Amalgamated’s investment activities during the last quarter of 2018 and the first month of 2019. The only securities held by Amalgamated at October 1 were $30 million of 10% bonds of Kansas Abstractors, Inc., purchased on May 1 at face value and held in Amalgamated’s trading portfolio. The...
A. Record the journal entries for the December transactions.** Must show formulas in cells. Record the...
A. Record the journal entries for the December transactions.** Must show formulas in cells. Record the following entries in general journal form for December, 2020: December 1: Recorded sales on account of $100,000, 2/10, net 30. Cost of inventory was 63,500. Company uses the net method for accounting for sales. December 2: Purchased Land for a future building site for $700,000, paying $200,000 down and signed a 5%, 90-day note for the balance. December 3: Bought back 1000 shares of...
Please solve using the shown Workbook in excel Balance Sheet & Income Statement Coast Ltd., which...
Please solve using the shown Workbook in excel
Balance Sheet & Income Statement Coast Ltd., which has just started trading on 1 January 2019. has the following account balances prior to the recording of the final month of the year: Account Balances as at 30 November 2019 Account $ Cash $5 300 Accounts receivable $6 400 Stock of Supplies $11 600 Property, Plant & Equipment -cost $36 000 Accounts payable $3 000 Interest payable S 100 Bank Loan $12 000...
Please solve for the cells with question marks and show excel equation A1 X fx Chapter...
Please solve for the cells with question marks and show excel
equation
A1 X fx Chapter 4: Applying Excel A $4 3 Data 4 Selling price per unit $50 5 Manufacturing costs: 6 Variable per unit produced: 7 Direct materials $11 8 Direct labor $6 9 Variable manufacturing overhead $3 10 Fixed manufacturing overhead per year $120,000 11 Selling and administrative expenses: 12 Variable per unit sold 13 Fixed per year $70,000 14 15 Year 1 Year 2 16 Units...
second picture is part 1, need help with part two please 4. Identify, analyte, record, and...
second picture is part 1, need help with part two please
4. Identify, analyte, record, and post transactions (THERE ARE 4 PARTS TO THIS QUESTION): King Toot's music! store sels musical Instruments and other related merchandise to customers. The following is a list of King Toot's account balances at the beginning of December (le, as of December 14, 2017): Cash: $18.750; Accounts Receivable (A/R): $11,980, Inventory: $20,800, Equipment: $34,400; Accounts Payable (A/P): $13,930; Notes Payable (N/P) $55,000; Common Stock $17,000....
AutoSave Off HD Unit 1 Project Fall 2020 (2) - Protected View - Excel guada gucci...
AutoSave Off HD Unit 1 Project Fall 2020 (2) - Protected View - Excel guada gucci GG File Home Insert Draw Page Layout Formulas Data Review View Help O Search Share Comments i PROTECTED VIEW Be careful—files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X H16 fox 1 J к L N O P P Q R S т U A B с D E F G...
212,482 Consolidated Balance Sheets - USD $ $ In Mill 2 Current Assets Cash and cash...
212,482 Consolidated Balance Sheets - USD $ $ In Mill 2 Current Assets Cash and cash equivalents Martable securities Note 4) Accounts and notes receivable et of lowance of $278 for 2017 id $212 for 2016) Inventaries Note 6) Equipment on operating l o te 7) 8 Other current N ote 4 Note 12 at VE 9. Current held for sale Note 3) 10 Total currentes 11 Non-current Assets 12 Equity in news of nonconsolidated affiliates Note 8) 13 Property,...
2. Prepare journal entries to record the following transactions involving both the short-term and long-term investments of HDX Inc., all of which occurred during calendar year 2019. a. On February 15, paid $100,000 cash to purchase Apex's 90-day short-term notes at par, which are dated February 15 and pay 5% interest (classified as short-term held-to- maturity). O B. On March 22, bought 1,000 shares of Fox Industries common stock (2% of Fox's outstanding stock) at $25 cash per share plus...
4 The following information is provided for the newly formed corporation, LAX, Inc. on January 1, 2023: 5 Treasury Outstanding Authorized Issued Common stock, $1 par value: 100,000,000 35.000.000 34,510,000 Preferred stock, 6.5%, $100 par value: 1.000.000 500,000 Treasury stock, $42.35 basis: 490.000 10 11 1. On 3/31/23, LAX, Inc. issued 15,000,000 shares of of common stock in a seasoned offerring for $50.88 per share. Record the journal entry: 12 13 Date Accounts Debits Credits 14 15 2023/3/31 16 17...
Please show in excel like above,
thanks!
Balance Sheet & Income Statement Coast Ltd., which has just started trading on 1 January 2019. has the following account balances prior to the recording of the final month of the year: Account Balances as at 30 November 2019 Account $ Cash $5 300 Accounts receivable $6 400 Stock of Supplies $11 600 Property, Plant & Equipment -cost $36 000 Accounts payable $3 000 Interest payable S 100 Bank Loan $12 000 Contributed...
A. Record the journal entries for the December transactions.** Must show formulas in cells. Record the following entries in general journal form for December, 2020: December 1: Recorded sales on account of $100,000, 2/10, net 30. Cost of inventory was 63,500. Company uses the net method for accounting for sales. December 2: Purchased Land for a future building site for $700,000, paying $200,000 down and signed a 5%, 90-day note for the balance. December 3: Bought back 1000 shares of...
Please solve using the shown Workbook in excel
Balance Sheet & Income Statement Coast Ltd., which has just started trading on 1 January 2019. has the following account balances prior to the recording of the final month of the year: Account Balances as at 30 November 2019 Account $ Cash $5 300 Accounts receivable $6 400 Stock of Supplies $11 600 Property, Plant & Equipment -cost $36 000 Accounts payable $3 000 Interest payable S 100 Bank Loan $12 000...
Please solve for the cells with question marks and show excel
equation
A1 X fx Chapter 4: Applying Excel A $4 3 Data 4 Selling price per unit $50 5 Manufacturing costs: 6 Variable per unit produced: 7 Direct materials $11 8 Direct labor $6 9 Variable manufacturing overhead $3 10 Fixed manufacturing overhead per year $120,000 11 Selling and administrative expenses: 12 Variable per unit sold 13 Fixed per year $70,000 14 15 Year 1 Year 2 16 Units...
second picture is part 1, need help with part two please
4. Identify, analyte, record, and post transactions (THERE ARE 4 PARTS TO THIS QUESTION): King Toot's music! store sels musical Instruments and other related merchandise to customers. The following is a list of King Toot's account balances at the beginning of December (le, as of December 14, 2017): Cash: $18.750; Accounts Receivable (A/R): $11,980, Inventory: $20,800, Equipment: $34,400; Accounts Payable (A/P): $13,930; Notes Payable (N/P) $55,000; Common Stock $17,000....
AutoSave Off HD Unit 1 Project Fall 2020 (2) - Protected View - Excel guada gucci GG File Home Insert Draw Page Layout Formulas Data Review View Help O Search Share Comments i PROTECTED VIEW Be careful—files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X H16 fox 1 J к L N O P P Q R S т U A B с D E F G...
212,482 Consolidated Balance Sheets - USD $ $ In Mill 2 Current Assets Cash and cash equivalents Martable securities Note 4) Accounts and notes receivable et of lowance of $278 for 2017 id $212 for 2016) Inventaries Note 6) Equipment on operating l o te 7) 8 Other current N ote 4 Note 12 at VE 9. Current held for sale Note 3) 10 Total currentes 11 Non-current Assets 12 Equity in news of nonconsolidated affiliates Note 8) 13 Property,...
Most questions answered within 3 hours.
-
You purchase your daily coffee at the Chemist’s Coffeehouse and
have a choice of two cups:...
asked 27 minutes ago -
Which of the following pairs of chemicals could be used to make
a buffer solution?
A.)...
asked 13 minutes ago -
Problem 16-51 Sales
Activity Variance (LO 16-3)Odessa, Inc., reports the following
information concerning operations for the...
asked 52 minutes ago -
Pictured on the right are thee point charges Q1 = 18.4 μC, Q2 =
-30.6 μC,...
asked 54 minutes ago -
A graduate student is conducting research in psychology and
needs to obtain the IQ scores of...
asked 1 hour ago -
R2.84: There are 2 defective products in a production lot of 10.
An inspector randomly selected...
asked 2 hours ago -
Consider the following equilibrium system: COCl2(g) CO(g) +
Cl2(g) A 10.00 L evacuated flask is filled...
asked 3 hours ago -
1) What are the two distinct steps that one needs to perform
when developing a data...
asked 3 hours ago -
2) Write a C++ program that uses a class called “Degree” to
obtain the trigonometric
values...
asked 4 hours ago -
1. In eukaryotic cells the genomes of
&
asked 4 hours ago -
The standard enthalpy of propanol (C3H7OH) is -303.0 kJ/mol.
Compute both of the
gross and net...
asked 4 hours ago -
Why PWM using H-bridge for control motor speed is more power
effiecient than the linear amplifier...
asked 4 hours ago