Periodic inventory by three methods

The units of an item available for sale during the year were as follows:

There are 1,900 units of the item in the physical inventory at December 31. The periodic inventory system is used. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.

1. Determine the inventory cost by the first-in, first-out method. Round your answer to the nearest dollar.

   $  

2. Determine the inventory cost by the last-in, first-out method. Round your answer to the nearest dollar.

   $  

3. Determine the inventory cost by the weighted average cost method. Round your answer to the nearest dollar.

   $  

A stock is expected to pay a dividend of $10 in one year. Its future annual dividends are expected to grow by 20% pa. The next dividend of $10 will be in one year, and the year after that the dividend will be $12 (=10*(1+0.2)^1), and a year later $14.4 (=10*(1+0.2)^2) and so on forever.

Its required total return is 50% pa. The total required return and growth rate of dividends are given as effective annual rates.

Calculate the payback period of buying the stock and holding onto it forever, assuming that the dividends are received as at each time, not smoothly over each year. Note that you will have to find the price of the stock first.

Select one:

a. 1 year.

b. 2 years.

c. 3 years.

d. 4 years.

e. 5 years.

You are analyzing the returns of a mutual fund portfolio for the past 5 years.

Question 6: What is the standard deviation of the returns?   29.28%

Question 7:  Use Excel to compute the VaR at the 1% level (you can write the Excel formula as your work).

Answer Question 7 plz

These are the yearly returns for a mutual fund. . Year Return 2013 15.00% 2014 -8.00% 2015 7.50% 2016 9.11% 2017 10.00% 2018 -7.62% 2019 4.00% Calculate the geometric return. For the Fidelity mutual fund exercises, this is also known as the "average annual return". Select one: a. More than 5.0% b. Less than 2.0% c. 2.0% to 3.0% d. 4.0% to 5.0% e. 3.0% to 4.0%

A company has a December year end and creates checks to pay their vendors towards the end of the month. The company creates all the proper journal entries at the time of creating the checks, but they do not mail the checks until January. Explain which, if any financial ratios are affected by this decision. Explain why this decision would be made.

A new molding machine is expected to produce operating cash flows of $109,000 a year for 4 years. At the beginning of the project, inventory will decrease by $8,700, accounts receivables will increase by $9,500, and accounts payable will decrease by $5,200. All net working capital will be recovered at the end of the project. The initial cost of the molding machine is $319,000. The equipment will be depreciated straight-line to a zero book value over the life of the project. No bonus depreciation will be taken. The equipment will be salvaged at the end of the project creating an aftertax cash inflow of $51,600. What is the net present value of this project given a required return of 14.2 percent? (show work not in excel)

The number of initial public offerings of stock issued in a​ 10-year period and the total proceeds of these offerings​ (in millions) are shown in the table. The equation of the regression line is

ModifyingAbove y with caret equals y=48.918x+18,133.57.

Complete parts a and b.

​(a) Find the coefficient of determination and interpret the result.

nothing

​(Round to three decimal places as​ needed.)

Designers need to design how to continue the air in a new building with a 40-year life. Four alternatives
are available, both of which have 20-year lives. Costs are given below. Use 12% interest rate.
A B C D
First Cost 90,000 60,000 85,000 72,000
SV in 20 years 10,000 8,000 12,000 9,000
Ann. Fuel
Cost
3,000 5,000 4,500 3,500
Ann. Maint.
Cost
2,200 3,200 1,800 2,400
Tax (%) of FC 3% 1.5% 2.3% 1.7%
a. What is the present worth of alternative D?(10 points)
b. What is the ROR of Alternative A?(10 points)
c. Which is the best alternative? Use ROR on additional investment.(20points)

(C) ZAPRYL BHD is in the process to finalise its financial statements for the year ended 31 December 2019. Based on its current records, the profit before tax is RM3,200,000 (2018: RM3,000,000). However, the followings have been discovered:

(a) Sales invoices dated 24 December 2018 amounted to RM8,000 and 27 December 2019 amounted to RM10,000 were both fake.

(b) An investment property was purchased in January 2015 at a cost of RM2,000,000 with a useful life of 25 years and was accounted using the cost model. However, for the financial year 2019, the management decided to use the revaluation model whereby the fair value on 31 December 2019 is RM2,800,000 (2018 and 2017: RM2,500,000).

(c) A machinery which was purchased on 4 January 2015 at a cost of RM100,000 has been depreciated using the straight-line method for 10 years useful life with a residual value of RM10,000. Assessment revealed that the machine can be used for another three years with no changes in residual value.

Required:

(i) Classify each of the above events according to MFRS 108 Accounting Policies, Changes in Accounting Estimates and Errors.

(ii) Determine the effect of each of the above events on the profit before tax for the financial year ended 31 December 2018 and 2019 after the adjustments have been recorded.

A year ago, an investor bought 1,000 shares of a mutual fund at the net asset value of $25 per share. The fund distributed dividends of $2.5 and capital gains of $2. Today, the NAV is $28.

a. What’s the holding period return?

b. Assuming all dividends and capital gain distributions are reinvested into additional shares of the fund at an average price of $26 per share. What’s holding period return?