Question
You are the Chief Financial Officer (CFO) of Xero Limited (XRO.AX). Recently, XRO is venturing into the end-to-end encryption-based accounting software and partnering with the
You are the Chief Financial Officer (CFO) of Xero Limited (XRO.AX). Recently, XRO is venturing into the end-to-end encryption-based accounting software and partnering with the blockchain giant ULTRA. Two companies are working together to develop a blockchain-based hyperscale data center for the cloud-based encryptions. Building such data center would require a large investment from XRO. As a result, the development of this new data center will initially require a capital expenditure equal to 30% of the total cash for the fiscal year ended 31 December 2021 (i.e., = 0). This new data center is expected to have a life of five years. The depreciation is calculated using the straight-line method. Both the estimated and actual salvage values are assumed to be zero (i.e., to protect the patient privacy and confidentiality, this data center will be destroyed at the end of the useful life. Hence, the actual salvage value is zero). First-year revenue from this data center is expected to be 8% of the total revenue for XROs fiscal year ended 31 December 2021. The data centers revenue is expected to grow at 15% for the second year, then 10% for the third, and 5% annually for the final two years of the expected life of the project. Your role in this project is to determine the cash flows associated with this data center. The CEO of XRO has informed you that the profit margin is similar to the rest of the XROs existing projects (i.e., gross profit divided by total revenue). Section 1: Complete this section using Excel. For calculation purposes, assume we are on 1 January 2022. 1. You are now ready to determine the free cash flow. Compute the free cash flow for each year using the financial reports provided for XRO for 2021. Set up the computation of the free cash flow in separate, contiguous columns for each year of the data centers life in Excel. Be sure to make outflows negative and inflows positive. a. You may assume that the data centers profitability will be similar to XROs existing projects in 2021 and estimate its profit margin by dividing XROs gross profit by its total revenue. b. Determine the annual depreciation by assuming XRO depreciates the data center by the straight-line method over a 5-year life (both the estimated and the actual salvage values are zero). c. Assume that XROs effective tax rate is 30%. For simplicity, assume that the tax credit cannot be carried forward and XRO does not have any existing tax liabilities. Then calculate tax expense for each year.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started