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.
-
The energy levels of a quantum mechanical system are given by
the equation: En = -hfo/√n^2+9....
asked 10 minutes ago -
Calculate the molality of an aqueous solution of iron (II)
nitrate with a solute mole fraction...
asked 20 minutes ago -
Use the adjusted trial balance for Stockton Company. Determine
the current asset.
Stockton Company
Adjusted Trial...
asked 12 minutes ago -
Mry has net and taxable income of $55000; her claim for
charitable donation is $4000. How...
asked 29 minutes ago -
Independent random samples were selected from two binomial
populations, with sample sizes and the number of...
asked 30 minutes ago -
Calculate the wavelength of light (in nanometers) emitted from a
hydrogen atom if the electron is...
asked 41 minutes ago -
Please answer in Python 3! 16.2** (Maximum increasingly ordered
subsequence) Write a program that prompts the...
asked 46 minutes ago -
Energy is carried by which of the following waves?
(Select all that apply)
a) light wave...
asked 46 minutes ago -
(Part 1) An investor wants to have $1,000,000 when she retires
in 20 years. If she...
asked 47 minutes ago -
ESP8266/Arduino UNO and temperature sensor MCP9700A.
Temperature sensor gives incorrect temperature readings in
celsius.
Both ESP8266...
asked 48 minutes ago -
1. Why has Dunkin’ Donuts increased its focus on
coffee?
2. Describe the strategy that Dunkin’...
asked 56 minutes ago -
two lady bugs sit on a rotating disk without slipping. lady bug
1 is half away...
asked 1 hour ago