Tesla has a manufacturing building that they paid $500,000 on December 31, 2020. To pay for the building, they took a 30-year fixed mortgage loan at 5%. for the building. The mortgage payment is paid at the end of each month with cash. Complete the Mortgage Payment worksheet using the PMT and PPMT functions. You should use each function ONCE on the Mortgage Payment worksheet. Please make the needed journal entry for Dec. 31, 2021, only. You can just type in the amount for the journal entry. Don’t have to use cell references. Hint: Don’t forget to put a negative sign in front of the function.

The manufacturing building should be depreciated over 15 years using straight-line depreciation. It will be fully depreciated. Please the SLN function. Please make an end-of-year journal entry for 2021. You can just type in the amount for the journal entry. Don’t have to use cell references.

On January 1^st, 2021, the company bought 4 trucks for $200,000 from Rivian. The trucks should be depreciated using a double declining balance over a five-year period. At the end of five years, each truck is expected to be sold for $10,000. Please use the DDB function only ONCE to calculate the depreciation in each of the five years. Please make an end-of-year journal entry for 2021. You can just type in the amount. Don’t have to use cell references.

Tesla is considering buying $200,000 of specialized equipment. The purchase would be made on January 1^st, 2021. The company would expect to have positive cash flows of $70,000 in 2022, $80,000 in years 2023 and 2024, and $50,000 in 2025. The equipment would not have any salvage value. The company uses a discount rate of 10%. Please calculate the Internal Rate of Return (IRR) and Net Present Value (NPV) functions so the company can decide whether to purchase the equipment. Use the IRR and NPV worksheet. No journal entries are required. Use the worksheet provided.

Elon Musk is the CEO of Tesla and pays special attention to the stock price of Tesla. Using the STOCKHISTORYfunction, create a table showing the closing price of Tesla stock for each day during the month of January 2021. Use the worksheet provided.

Tesla is considering issuing 10-year bonds with a face value of $1,000. The coupon rate is 5% so the bonds will pay 5% of the $1,000 face value in interest every year, or $50. However, because interest is paid semiannually in two equal payments, there will be 10 coupon payments of $25 each. The $1,000 will be returned at maturity. Finally, the required rate of return (discount rate) is assumed to be 8%. Prospective bond holders want to know what the present value of the bonds are. Please use the present value (PV) function to determine this. Use the worksheet provided.