Question

Please solve these two problems without using EXCEL and provide your work. Write down the formulas...

Please solve these two problems without using EXCEL and provide your work. Write down the formulas you used to solve the problems and solve the problems.

1. Assume your company purchased $145,305 worth of office equipment (7-year useful life) and sold it for $32,999 at the end of year 7. What is the book value of the property at the end of year 2 using MACRS depreciation and a 5% MARR. (ANSWER IS 88,956)

2. The Steinbrenner family donated $3.7 million for the construction of a new stadium on the MIT campus in 1955. At the same time the family donated an additional $3.7 million as a gift to be used for the construction of a future stadium. If MIT invested the gift in an account with an interest rate of 9.7%, what was the value of the gift in millions of actual dollars in 2010 assuming that the average inflation rate was 4.7%? Note please express your answer in millions of dollars rather than dollars (e.g., 1.2 not 1,200,000) (ANSWER IS 601.96)

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Answer 1)
In MACRS salvage value is not needed
Using MACRS tables for depreciation
useful life 7 years
Year 1 depreciation
145305 14.30% 20778.62 Book value at year end 1= 145305-20778.62 124526.4
Year 2 depreciation
145305 24.50% 35599.73 Book value at year end 1= 124526.4-35599.73 88926.67
Answer 2)
FV in 1955 for 2010 will be
=3.7 * (1.097)55 601.96
Add a comment
Know the answer?
Add Answer to:
Please solve these two problems without using EXCEL and provide your work. Write down the formulas...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • f-i please The accompanying data are from a simple random sample of 10 Hollywood movies that...

    f-i please The accompanying data are from a simple random sample of 10 Hollywood movies that were based on best-selling novels. The variables considered are y = first year box office receipts (in millions of dollars), X = total production costs (in millions of dollars), x2 = total promotional costs (in millions of dollars), and Xa= total book sales in millions of dollars). X2 4.7 8.5 12.9 5.2 10.7 5.1 5.8 2.1 8.4 8.8 15.1 12.2 10.6 3.1 2.9 85.1...

  • Please show all work. If using excel please show formulas. A proposed cost-saving device has an...

    Please show all work. If using excel please show formulas. A proposed cost-saving device has an installed cost of $695,000. The device will be used in a five-year project but is classified as three-year MACRS property for tax purposes. The required initial net working capital investment is $105,000, the marginal tax rate is 25 percent, and the project discount rate is 11 percent. The device has an estimated Year 5 salvage value of $80,000. What level of pretax cost savings...

  • The answer is shown in the picture, i want to know how they got it, please show all your work and if you are using excel please show your formulas, Thank You and good luck. Toll lanes on a section of...

    The answer is shown in the picture, i want to know how they got it, please show all your work and if you are using excel please show your formulas, Thank You and good luck. Toll lanes on a section of the 1-40 freeway are being considered in order to reduce traffic congestion and travel times Since this is a government project, the B-C ratio method must be applied in the evaluation. Construction costs of the project are estimated to...

  • Please don't use excel to solve the problems and show your work. 16.1. (a) Calculate the...

    Please don't use excel to solve the problems and show your work. 16.1. (a) Calculate the amount realized at the end of 7 years through annual deposits of $1000 at 10 percent compound interest. (b) What would the amount be if interest were compounded semiannually? 16.2. A young woman purchases a used car. After down payment and allowances, the amount to be paid is $8000. If money is available at 10 percent, what is the monthly payment to pay off...

  • Please solve the following problem WITHOUT USING EXCEL. Please type your answer. Roberto Inc. is a...

    Please solve the following problem WITHOUT USING EXCEL. Please type your answer. Roberto Inc. is a manufacturing company. The company has always followed their ideal capital structure which the management insists is 40% debt and 60% equity capital. The company can issue bonds for 9% coupon rate with 22 years to maturity. The interest is paid semi-annually. The bonds can be issued with a price of $835.42 today. Roberto's marginal tax rate is 40%. For cost of equity, the company...

  • without using a financial calculator or excel. Please provide all formula used and variables with clear...

    without using a financial calculator or excel. Please provide all formula used and variables with clear steps (10) Please write your answer in the answer book provided. Show your workings. Circle your final answer. (a) A life insurer sells a 15-year term certain annuity which pays an annual effective rate of interest i = 4% to the policyholder. If the customer wants to purchase the annuity which pays $1,500 at the end of each year for 15 years, what is...

  • Solve this with correct answer please. Don't used excel show me your work please. This is...

    Solve this with correct answer please. Don't used excel show me your work please. This is IEM class 6) (25 points) A $10,000, 10-year municipal bond is offered at a premium for $10,500. The bond rate is 8% per year compounded quarterly. If John wishes to earn 7.5% per year compounded quarterly on the bond investment, should he purchase the bond assuming he keeps the bond till it matures and then redeems it at face value? Explain. Show all work.

  • without using financial formulas just basic math formulas are eligible. Please provide all formula used and...

    without using financial formulas just basic math formulas are eligible. Please provide all formula used and variables with clear steps. Please use Goal Seek Tool in excel. EXCEL Question 1 (Home Loan) (3marks] Construct an EXCEL spreadsheet, which projects cash flows of a home loan with yearly loan repayments, ie. the loan is paid by payments at the end of each year for n years, until the loan is completely paid off. Please use your spreadsheet to answer the following...

  • please this question is giving me problem. please help me to solve for it .please Excel...

    please this question is giving me problem. please help me to solve for it .please Excel Online Structured Activity: Lease versus Buy Sadik Industries must install $1 million of new machinery in its Texas plant. It can obtain a bank loan for 100% of the required amount. Alternatively, a Texas investment banking firm that represents a group of investors believes that it can arrange for a lease financing plan. Assume that these facts apply: 1. The equipment falls in the...

  • Show what formulas are used in excel to solve problems please. What role does capital budgeting...

    Show what formulas are used in excel to solve problems please. What role does capital budgeting play in the firm's overall financial planning program? answer must be at least 300 words. 2 COMMON STOCK VALUATION Crosby Corporation common stock paid $1.32 in dividends last year and is expected to grow indefinitely at an annual 7 percent rate. What is the value of the stock if you require an 11 percent return? 4 6 DATA 7 Growth rate 8 Dividend (Do)...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT