Solve using excel
You are going to buy a $350,000 building in cash and will depreciate the asset over 30 years. Assume the building value will increase 2% per year each year for 20 years. If inflation is constant at 2.2% per year, what is the opportunity cost of the building?
Solve using excel You are going to buy a $350,000 building in cash and will depreciate the asset over 30 years. Assume the building value will increase 2% per year each year for 20 years. If inflation...
Suppose a corporation is allowed to depreciate a $10,000 asset over 4 years using, straight-line depreciation. Assume that the discount rate is 10%. Suppose that the corporation pays a 35% tax on its profits every year. What is the present discounted value of the tax deduction from the depreciation— that is, what is the value today of the tax savings over the 4 years due to the depreciation allowance?
Equipment cost 78,000 Salvage Value 2500 Life 6 years Units over life 678,000 Depreciate using Excel SL DDB SYD Units of Activity Year 1 Year 2 Year 3 Year 4 Year 5 Year 6
GIPI will depreciate the
gymnasium building using the straight-line method over 10 years
with a residual value of $5,000. Gym equipment will be depreciated
using the double-declining-balance method, with an estimated
residual value of $4,500 at the end of its four-year useful life.
Record depreciation on 1/31 equal to one-twelfth the yearly amount.
Record the transaction. -The General journal below is wrong when i
clicked on check answer, if someone could correct it that would be
great, thank you!
Grid...
Using Excel Please
5. Growing Annuity Assume you want to retire in 35 years and save a $15,000 at the end of the first year. Assume you will earn 7% annually on your investment and you expect 2% inflation before retirement. After you retired, you expect to live for another 30 years. Assume you can earn a nominal annual rate of 4% and you expect inflation to be 3% during retirement. a) Calculate how much money you are accumulating by...
"Engineering Economics"
How do you solve this using excel?
1. A machine costs $35,000 to buy and $5,000 per year to operate and maintain. It will have a salvage value of $8,000 in 9 years. It will generate $10,000 per year in net revenue for the first four years, and then the revenue will fall by $1,000 each year after. If the company purchasing the machine uses a MARR of 7% to make project, find the NPW, NEW, and AW....
You purchased a building, equipment and a truck for $700,000 cash. The building has an appraisal value of $400,000, the equipment $300,000 and a truck appraised at $100,000 Determine the cost to be assigned to each asset and prepare the journal entry to make the purchase. JOURNAL ENTRY The building has a 20 year life expectancy and a $25,000 salvage value. It will be depreciated using the straight-line method. Assume at the end of the 8th year the building is...
1) You want to buy a boat in 20 years. It costs $15,000 now al a boat in 20 years. It costs $15,000 now and the cost will roughly increase by 3% per year. Suppose you make constant deposits every an account at the end of each year, and then let the mom Suppose you make constant deposits every year for 10 years into end of each year, and then let the money sit for ten years, assuming a 2%...
Question Completion Status: If you buy a $400,000 condo with 100% financing over 30 years at 10% interest per year, what will your annual payments be? Assume you are allowed to make annual payments. 42,432 58,989 88,455 89,560 QUESTION 11 What is the effective annual rate (EAR) for a 12% APR assuming monthly compounding? 12.2% 12.5% 12.7% 12.9% QUESTION 12 If you have a loan with a 12% interest rate this past year and inflation was 10%, what was the...
should be explain it on excel
Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car...
Exercise 14-42 (Algo) Effects of Current Cost on Performance Measurements (LO 14-2, 5)Upper Division of Lower Company acquired an asset with a cost of $580,000 and a four-year life. The cash flows from the asset, considering the effects of inflation, were scheduled as follows. YearCash Flow1$185,0002240,0003285,0004310,000 The cost of the asset is expected to increase at a rate of 20 percent per year, compounded each year. Performance measures are based on beginning-of-year gross book values for the investment base. Ignore taxes. Required:a. What is...