Monthly stock prices 2011 January 0.258333   February 0.258333   March 0.25   April 0.258333   May 0.266667   June 0.258333   July 0.258333   August 0.266667   September 0.266667   October 0.266667   November 0.258333   December 0.266667   Required Using excel calculate each month returns using natural log method Using excel calculate annual average return for 2011 Using excel calculate annual volatility for 2011

Q: Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's…

A: The objective of the question is to calculate the average rate of return for Stocks A and B over the…

Q: Refer to the income statements for The Gap, Inc., presented below. a. Prepare common-size income…

A: Common Size Statement:   An income statement in which each item is expressed as a percentage of the…

Q: Operating Income 2015 2016 Change 2015 v 2016 September 186,538.33 158,575.11 27,963.22 October…

A: To calculate the average monthly rate of decline, we need to find the total change in operating…

Q: Current ratio 2.5:1 Quick ratio 1.1:1 Average collection period (365-day year) Inventory turmaver…

A: Hello. Since your question has multiple sub-parts, we will solve first three sub-parts for you. If…

Q: Find the quote for the Lake Lead Group. Assume that the dividend is constant. a. What was the…

A: Given: Lake lead Grp Amount Highest price 56.26 Low price 33.87 Dividend 1.99 Dividend…

Q: Provide explanationations on the gearing and interest coverage ratios by making comparison between…

A: The interest coverage ratios are one of the ratios which a company measures so that it will be help…

Q: Computing trend analysis and return on common equity Net sales revenue, net income, and common…

A: Trend Analysis: Trend analysis is one form of horizontal analysis. It helps the user to calculate…

Q: •What is the covariance of returns between stocks A and B?   year    Year              Return A…

A: Covariance is the proportion by which two sets of investment returns oscillate in relation to each…

Q: Part 1 Calculate the annual returns. What was the arithmetic average annual return for stock B? 4+…

A: Arithmetic Average Return: It refers to the return on investment computed by adding the returns for…

Q: Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's Returns,…

A: Here,YearStock A's ReturnStock B's…

Q: You’ve collected the following information from your favorite financial website. 52-Week Price Stock…

A: The value of the firm using the dividend growth model is calculated by ascertaining the dividend…

Q: Here are the returns on two stocks. Digital Executive Cheese Fruit January +13 +6 February -2 +1…

A: As per our guidelines, we are supposed to answer only 3 sub-parts (if there are multiple sub-parts…

Q: Question: Calculate the average annual growth rate of Microsoft from the fiscal year ending 2009…

A: Calculate the average annual growth rate as follows:

Q: esented here are summarized data from the balance sheets and income statements of Wiper Inc.:…

A: Ratio Analysis -Ratio Analysis is a important technique to analyze the two years of financials of…

Q: 3. 52-Week high Low Stock SYM Div Yld % PE Vol 100s Close Net. Chg Hi Lo 70.25 47.30 Goodyear GT…

A: Listed stocks on recognise market are traded on daily basis. When market opens, it shows the all…

Q: You've collected the following information from your favorite financial website. 52-Week Price Div…

A: Here's a detailed explanation for better understanding. The two-stage dividend discount model can be…

Q: You've collected the following information from your favorite financial website. 52-Week Price Div…

A: A stock is a capital market security which offers the investor an ownership interest in the…

Q: Mercedes, Company has the following quarterly financial information. 3rd Quarter $ 925,300 317,800…

A: The ratio is the technique used by the prospective investor or an individual or strategist to read…

Q: A B D Closing Closing Closing Market Price for Price for Index value 1 Date AMZN ВАС 2 2/1/2017 з|…

A: The formula for the calculation of return is as follows: Monthly Rate of return=Present month…

Q: current ratio,quick ratio and cash ratio and give recommendation

A: Ratio analysis is the way of analyzing the financial information based on certain metrics computed…

Q: Year Sales Trend % Gross Profit Trend % Net Profit Loss Trend % EBIT Trend % 2016 2017 2018 2019…

A: Trend analysis shows how much percentage is the sale/gross profit etc. of current year on the basis…

Q: Projecting NOPAT and NOA Using Parsimonious Forecasting Method Following are Logitech's sales, net…

A: Step 1: Calculating NOPAT for 2020To calculate NOPAT for 2020 using the parsimonious forecasting…

Q: explain each ratio of this list what happened in 2019, 2020, 2021? List of Ratios 2019 2020 2021…

A: Gross profit margin: Formula of Gross Profit Margin=(Sales Revenue - Cost of Sales)Sales Revenue*…

Q: How do you calculate net sales? Also... Do you only look at current year data or do you factor…

A: Net Sales=Gross Sales-Returns-Allowances-Discounts where, Gross sales=the total unadjusted sales of…

Q: Compute trend percentages forRolling Hills ​Realtors' net revenue and net income for the following​…

A: TREND PERCENTAGE Trend Percentage helps to Comparison the Elements of the Financial Statement of the…

Q: Looking at this graph, where do you think you can find the Beta? Remember that a Beta roughly…

A: Beta is the systematic risk involved with the asset. It tell how sensitive the asset returns are to…

Q: According to your research, the growth rate in dividends for DR Dime for the previous 10 years has…

A: Given data Current dividend(D0 )= $0.93 Growth rate(G) = -13% Current price(P0 ) = $15.56

Q: The following is data for 123 Corp: Book value, Dec 31 2016 Comprehensive income Dividends Required…

A: Normal income is calculated as the book value at the beginning of the year multiplied by the…

Q: An analysis of the liquidity and efficiency ratios for XYZ Trading shows the following results.…

A: 1: Johnson, B. K. (2022). The Development and Control of Soft Robotic Materials Driven by…

Q: Current Assets Cash Accounts Receivable Inventory Total Current Assets Fixed Assets Assets (SM) Net…

A: Ratio Analysis - The ratio is the technique used by the prospective investor or an individual or…

Q: You've collected the following information from your favorite financial website. 52-Week Price Div…

A: Given Information:  Price of Palm coal = 14.50 Dividend yield = 2.9%Growth rate = 4%

Q: Zoobilee Inc. reported the following sales and net income amounts: (in thousands) 2020 2019 2018…

A: Trend analysis Trend analysis is one of the methods of analysis performed on financial statements…

Q: Problem Set #3 Use the following information to answer the next three questions: The Last four years…

A: Step 1:Last four years, average annual returns,9.5%,19.4%,−6.2%,18.9%Sum of All above…

Q: Mercedes, Co. has the following quarterly financial information. Sales Revenue Cost of Goods Sold…

A: Ratios make it easier to compare an organization's performance to rivals or industry benchmarks.…

Q: Stock A and stock C have the following historical returns: Year Stock A Return Beta Stock C Return…

A: Year Stock A Return Beta Stock C Return Beta 2017 (18%) 0.80 (14.50) 0.90…

Q: Q Analysis of Financial Statement: The Balance Sheet Decent Limiled of December, 31 , 2017 on Assets…

A: Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…

Q: Year      AT&T Stock Returns       Market Index Returns  1                         8…

A: Beta of a stock is the slope between the market return and the stock return and is calculated in…

Q: Long-term debt ratio. 0.1 Times interest earned 10.0 Current ratio 1.6 Quick ratio 1.0 Cash ratio…

A: Solution:- Profit and loss accounts, balance sheets, and cash flow statements are the three main…

Q: What caused a decrease in the current ratio?

A: The current ratio is the ratio that is used to calculate the ability of the company to pay off its…

Q: 2. Sketch the drawdown curve based on the monthly stock prices listed below: Feb Mar Apr May Jun Jul…

A: Given…

Q: You've collected the following information from your favorite financial website. 52-Week Price Div…

A: As per the dividend growth model (DGM), the required return is determined by accounting for the…

Capital Gain

Any capital asset when sold can give the seller a higher or lower price from its purchase price leading to a capital gain or capital loss. The time period of holding an asset is decided based on if it is a long term or short-term capital gain. On that basis, the rate of taxation is decided if it is 20%, 15% or according to the tax brackets. The rate of taxation differs in the case of equity or debt, whether long or short term. The capital gain can be adjusted from capital loss to arrive at a net capital gain. The amount of gains and the exemption has to be reported in the tax return filed in the financial year in which the asset was transferred. The tax return can be filed quarterly, monthly, semi-annually or annually.