Calculate the accumulated depreciation amount for each year

Assignment Help Database Management System

Reference no: EM131461235

Assignemnt: New Investment Analysis

Project Description:

Flanky's, a small manufacturer of custom clothing for dogs and cats, is considering the purchase of a new building as part of its long-term strategic plan. You have been asked to conduct an analysis on the loan as well as an investment analysis using the NPV function based on an estimated series of cash flows generated by the new building and a required rate of return of 18%.

Instructions

1 Start Excel. Open the file named e06ws11_grader_a1.xlsx. Save the file with the name e06ws11Building_LastFirst, replacing LastFirst with your name.

2 On the BuildingAnalysis worksheet, in cell C5, calculate the amount to finance by subtracting the starting capital from the purchase price of the building.

3 In cell C10 calculate the end of period quarterly payment amount using the PMT function. Be sure the result is displayed as a positive number.

4 In cell C11 calculate the total cumulative interest that will be paid on the loan for all 28 end-of-the-period quarterly payments. Format as Currency. Be sure the result is displayed as a positive number.

5 In cell C13 calculate the total cost of the loan by adding the amount financed to the total cumulative interest.

6 In cell F13, calculate the net present value of the investment using the NPV function. Format as Currency with 2 decimal places, if necessary.

7 In cell I7 calculate the straight-line depreciation value of the building for year one and copy the formula down through year 7.

8 In cells J7:J13, calculate the accumulated depreciation amount for each year.

9 In cells K7:K13, calculate the book value of the asset at the end of each year of its useful life.

10 In cell I17, calculate the declining-balance depreciation value of the building for year one and copy the formula down through year 7.

11 In cells J17:J23, calculate the accumulated depreciation amount for each year.

12 In cells K17:K23, calculate the book value of the asset at the end of each year of its useful life.

13 Select cells I23:K23, click the Border arrow in the Font group, and then click Thick Bottom Border.

14 Ensure that the workbook contains the following worksheets (in this order): BuildingAnalysis, Documentation. Click Save, close Excel, and then submit the file as directed by your instructor.

Attachment:- mosken_e06ws11_grader_a1.xlsx

Reference no: EM131461235

Questions Cloud

Difference in income-total assets-total stockholders equity : Summarize the difference in income, total assets , and total stockholders' equity using the two different sets of accounting rules over the two year period.

What is the company cost of debt : If Wild Widgets, Inc., were an all-equity company, it would have a beta of 1.65. What is the company's cost of debt

Why do firms choose to make large increases in dividends : Why do firms choose to make large increases in their dividends or start a stock repurchase program?

Differences between sparta and athens : Characterize the major differences between Sparta and Athens, including your view of the strengths and weaknesses of each.

Calculate the accumulated depreciation amount for each year : calculate the accumulated depreciation amount for each year. Calculate the book value of the asset at the end of each year of its useful life.

South in the united states : Was slavery, and the racism and mistreatment of black people that accompanied it, something restricted to the South in the United States before the Civil War?

Portfolio will have a weighted average beta : Because she has lower than average risk tolerance, she carefully seeks out stocks so that her portfolio will have a weighted average beta of .80.

Watch the video - sharing the childs day with the parent : These parents say that their children seem to be playing a lot more than learning. Imagine the early childhood professionals interviewed.

Explain the quantitative and qualitative tools : For this assignment select either your own organization or an organization about which you know enough to review the supply chain processes.

User Account

All Pages