2and 3 2. From the following details prepare a statement of proprietary fund with as manydetails as possible.1) Stock velocity 62) Capital turnover ratio 23) Fixed assets turnover ratio 44) Gross profit turnover ratio 20%5) Debtor's velocity 2 months6) Creditor's velocity 73 daysGross profit was rs 60000. Reserves and surplus amount to 20000. Closing stock wasrs 5000 in excess of opening stock.3. From the following information for last 12 months compute theI.Re-order levelII.Minimum levelIII. Maximum levelIV. Average stock level for the components of X and YParticularsComponentsXYMaximum consumption in a monthMinimum consumption in a monthAverage consumption in a monthRe-order period in a monthRe-order quantity in units3000300020002000100010008 to 124 to 8800012000

“Since you have asked multiple questions, we will solve the first question for you. If you want any…

2. From the following details prepare a statement of proprietary fund with as many details as possible. 1) Stock velocity 6 2) Capital turnover ratio 2 3) Fixed assets turnover ratio 4 4) Gross profit turnover ratio 20% 5) Debtor's velocity 2 months 6) Creditor's velocity 73 days Gross profit was rs 60000. Reserves and surplus amount to 20000. Closing stock was rs 5000 in excess of opening stock.

2. From the following details prepare a statement of proprietary fund with as many details as possible. 1) Stock velocity 6 2) Capital turnover ratio 2 3) Fixed assets turnover ratio 4 4) Gross profit turnover ratio 20% 5) Debtor's velocity 2 months 6) Creditor's velocity 73 days Gross profit was rs 60000. Reserves and surplus amount to 20000. Closing stock was rs 5000 in excess of opening stock.

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter3: Data Visualization

Section: Chapter Questions

Problem 6P: The file MutualFunds contains a data set with information for 45 mutual funds that are part of the...

See similar textbooks

Similar questions

Suppose that you initially invested 10,000 in the Stivers mutual fund and 5,000 in the Trippi mutual fund. The value of each investment at the end of each subsequent year is provided in the table: Which of the two mutual funds performed better over this time period?
From the following details prepare a statement of proprietary fund with as many details as possible.1) Stock velocity 6 2) Capital turnover ratio 2 3) Fixed assets turnover ratio 4 4) Gross profit turnover ratio 20% 5) Debtors velocity 2 months 6) Creditors velocity 73 days Gross profit was Rs. 60000, reserves and surplus amount to 20000. Closing stock was Rs 5000 in excess of opening stock
The following information applies to Old Blues Advisors, a hedge fund: $288 million in assets under management (AUM) as of prior year-end 2% management fee (based on year-end AUM) 20% incentive fee calculated: net of management fee using a 5% soft hurdle rate using a high-water mark (high-water mark is $357 million) Current year fund return is 25% What is the total fee earned by Old Blues Advisorsin the current year?
The New Fund had average daily assets of $3.6 billion in the past year. The fund sold $414 million and purchased $514 million worth of stock during the year. What was its turnover ratio? (Round your answer to 2 decimal places.)
Consider the following trading and performance data for four different equity mutual funds: Fund W Fund X Fund Y Fund Z Assets Under Management, $ 289.40 $ 653.70 $ 1,298.40 $ 5,567.30 Avg. for Past 12 Months (mil) Security Sales, Past 12 Months (mil) $ 37.20 $ 569.30 $ 1,453.80 $ 437.10 Expense Ratio 0.33% 0.71% 1.13% 0.21% Pretax Return, 3-Year Avg. 9.98% 10.65% 10.12% 9.83% Tax-Adjusted Return, 3-Year Avg. 9.43% 8.87% 9.34% 9.54% a. Calculate the portfolio turnover ratio for each fund. b. Which two funds are most likely to be actively managed and which two are most likely passive funds? Explain. c. Calculate the tax cost ratio for each fund. d. Which funds were the most and least tax efficient in the operations? Why?
Consider the following trading and performance data for four different equity mutual funds: Fund W Fund x Fund y Fund z Assets under Management, $284.4 $662.1 $1,286.4 $5,564.6 Avg. for Past 12 months (mil) Security Sales, $44.6 $566.1 $1,455.6 $438.8 Past 12 months (mil) Expense Ratio 0.33% 0.75% 1.19% 0.24% Pretax Return, 3-year avg. 9.85% 10.65% 10.44% 9.73% Tax-adjusted Return, 3-year avg. 8.84% 8.84% 9.10% 9.04% Calculate the portfolio turnover ratio for each fund. Do not round intermediate calculations. Round your answers to two decimal places. Fund W: % Fund X: % Fund Y: % Fund Z: %
A mutual fund has total assets outstanding of $69 million. During the year, the fund bought and sold assets equal to $17.25 million. This fund's turnover rate was ________. 18.63% 28.5% 33.4% 25%
The Husky Fund’s portfolio consists of the following stocks at the beginning of the year: 500 Shares Stock IBM Price $ 180.00 4,000 Shares MSFT $ 30.00 There are 5000 shares outstanding. The fund charges 6% front-end load. The first year, the fund’s assets’ value increases by 10% and the fund pays out $10,000 as distributions to its investors. The fund charges management fees of .5% and 12b-1 fees of .5%. a) What is the fund’s NAV at the beginning and at the end of the first year? b) What is the reported return of the mutual fund in the first year? c) Suppose the mutual fund’s return stays the same each year. What is the return to an investor investing in the fund for 10 years?
The following are the data acquired from the financial statement of the firm: Cash on Hand …........ 1,500,000 Outstanding Fund Liabilities… 600,000 Assets Held by the Fund …800,000 Shares Outstanding …500,000 If the current price of the stock in the market is at $4.25, how much would be the upside/downside?
Consider a mutual fund with OMR400 million in assets at the start of the year and with 20 million shares outstanding. The fund invests in a portfolio of stocks that provides dividend income at the end of the year of OMR4 million. The stocks included in the portfolio increases in price by 10%, but no securities are sold and there are no capital gain distributions. The fund charges fees of 3%, which are deducted from the portfolio assets at year end. What is the net asset value at the start and end of the year? What is the rate of return for an investor in the fund?
Suppose that at the beginning of Year 1 you invested $10,000 in the Stivers mutual fund and $5000 in the Trippi mutual fund. The value of each investment at the end of each subsequent year is provided in the table below. Which mutual fund performed better? Please show steps in Excel Year Stivers Trippi 1 11,000 5,600 2 12,000 6,300 3 13,000 6,900 4 14,000 7,600 5 15,000 8,500 6 16,000 9,200 7 17,000 9,900 8 18,000 10,600
You purchased 1,900 shares of the New Fund at a price of $15 per share at the beginning of the year. You paid a front-end load of 5%. The securities in which the fund invests increase in value by 10% during the year. The fund's expense ratio is 2.1%. What is your rate of return on the fund if you sell your shares at the end of the year? (Do not round intermediate calculations. Round your answer to 2 decimal places.)