Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Since you are a Finance intern at MKD and have studied the International Finance course, the FD requires you to do the following calculationsand

image text in transcribed

image text in transcribed

1. Since you are a Finance intern at MKD and have studied the International Finance course, the FD requires you to do the following calculationsand analyse this project.1.You have studied different models (PPP, IRP, IFE, Macro model, Composite model) to predict the exchange rate. You mustselect one of these models and forecast the necessaryexchange rates to convert the cash flows from the PH project into the parent company currency. (Hint: Mondelez International prepares financial statements in USD). You are required to research and find the required data for this calculation. You need to explain your assumptionsand data and mention the data sourcesused.

2.Determine the net present value (NPV) of this project from the parent companys perspective and assumethe Company will remain unhedged.Should MKD proceed with this project?You should clearly state your assumptionsand justifyyour assumptions with valid research-basedevidence and additional data and information.

Initially, the plan is to produce products in Vietnam, set up one representative office in PH, and find a few distributors in PH to set up the product-introduction-store and distribute the products in PH. The Sales Director and the Finance Director discussed the following financial elements together: The Company has sufficient capacity to accommodate the PH business expansion within the first 12 months. However, it still needs to allocate the depreciation cost to the PH business in the first year. Furthermore, the Company requires an extra investment of 4.7 million USD for a new production line in year 2. The Company's general practice is to depreciate any investment over 10 years using the straight-line depreciation method. The Company will need an initial working capital of 4 million USD to run the business in PH to cover the expenses to rent the office, hire employees, and advertise the product in PH. KD is considering borrowing the funds required for the working capital investment and the extra investment in year 2. As an intern of the Company, FD has requested you to analyse different alternatives and suggest the best market to borrow. Should the Company borrow from the VN market or the PH market? 2 The project start date is April 01, 2022. Assuming the project will be terminated at the end of Year 5, when the business in PH will be sold to the PH company, MKD requires calculating the resale value of the business after 5 years. The FD has requested you to provide a calculation for this as well. You should mention your assumptions and justify your calculations. Price and demand information is given in Exhibit 1. The MKD also considers how to raise prices based on the inflation in PH. In addition, the SD also expects to achieve growth in demand for the products in the PH market. As the finance intern, you should research and propose an appropriate inflation rate and growth rate for MKD that can be achieved in the PH market during the period of the project. You should justify all your calculations and mention your assumptions. All costs (fixed and variable) are paid in PHP (Philippine Peso), and the interest cost will be determined depending on which country they would borrow from. All cash flows received by the subsidiary will be sent to the parent company (MKD in Vietnam) at the end of each year. The subsidiary will use its working capital to support ongoing operations. Assume no Withholding Tax (WHT). Assume MKD has to pay the regular corporate income tax as per the current regulation in PH, and there is no tax to pay in Vietnam for the earnings received from PH. Exhibit 1: Related financial Data Exchange rate VND 22840/USD Moon Cake 402,000 11.2 25% Cosy biscuits 3,718,000 4.7 25% Solite soft cakes 1,619,000 4.9 25% AFC crackers 1,133,000 5.3 25% Expected Volume (kg) to sell in PH in Year 1 Expected Selling Price per kg (in $) in Year 1 Percentage on Gross Revenue to pay for the distributor as Commission Current depreciation of the investment $/kg applicable for Year 1 Extra Investment needed in Year 2 in $ millions) Cost of goods sold $/kg excluding depreciation and delivery 0.11 0.05 0.07 0.10 1.0 4.58 1.5 2.35 1.2 2.52 1.0 2.48 cost 70% 30% 65% 35% Raw material and packing cost (% within COGS) Other costs (% within COGS) Annual delivery cost from VN to PH Annual overhead cost % of net revenue Annual advertisement cost % of net revenue 65% 65% 35% 35% 0.3% Gross Revenue 10% 10% 10% 10% 10% 10% 10% 10% 22,845 22,885 Exhibit 2: Additional information Exchange Rates for the USD as of 31/03/2022 (USD/VND) Bid Rate on USD Ask Rate on USD Inflation Rates (effective annual rates) Vietnam Average CPI Inflation in 2021 Vietnam Average CPI Inflation in 3 months of 2022 Philippines Average CPI Inflation in 2021 Philippines Average CPI Inflation in 3 months of 2022 3 1.84% 2.41% 3.90% 3.40% Initially, the plan is to produce products in Vietnam, set up one representative office in PH, and find a few distributors in PH to set up the product-introduction-store and distribute the products in PH. The Sales Director and the Finance Director discussed the following financial elements together: The Company has sufficient capacity to accommodate the PH business expansion within the first 12 months. However, it still needs to allocate the depreciation cost to the PH business in the first year. Furthermore, the Company requires an extra investment of 4.7 million USD for a new production line in year 2. The Company's general practice is to depreciate any investment over 10 years using the straight-line depreciation method. The Company will need an initial working capital of 4 million USD to run the business in PH to cover the expenses to rent the office, hire employees, and advertise the product in PH. KD is considering borrowing the funds required for the working capital investment and the extra investment in year 2. As an intern of the Company, FD has requested you to analyse different alternatives and suggest the best market to borrow. Should the Company borrow from the VN market or the PH market? 2 The project start date is April 01, 2022. Assuming the project will be terminated at the end of Year 5, when the business in PH will be sold to the PH company, MKD requires calculating the resale value of the business after 5 years. The FD has requested you to provide a calculation for this as well. You should mention your assumptions and justify your calculations. Price and demand information is given in Exhibit 1. The MKD also considers how to raise prices based on the inflation in PH. In addition, the SD also expects to achieve growth in demand for the products in the PH market. As the finance intern, you should research and propose an appropriate inflation rate and growth rate for MKD that can be achieved in the PH market during the period of the project. You should justify all your calculations and mention your assumptions. All costs (fixed and variable) are paid in PHP (Philippine Peso), and the interest cost will be determined depending on which country they would borrow from. All cash flows received by the subsidiary will be sent to the parent company (MKD in Vietnam) at the end of each year. The subsidiary will use its working capital to support ongoing operations. Assume no Withholding Tax (WHT). Assume MKD has to pay the regular corporate income tax as per the current regulation in PH, and there is no tax to pay in Vietnam for the earnings received from PH. Exhibit 1: Related financial Data Exchange rate VND 22840/USD Moon Cake 402,000 11.2 25% Cosy biscuits 3,718,000 4.7 25% Solite soft cakes 1,619,000 4.9 25% AFC crackers 1,133,000 5.3 25% Expected Volume (kg) to sell in PH in Year 1 Expected Selling Price per kg (in $) in Year 1 Percentage on Gross Revenue to pay for the distributor as Commission Current depreciation of the investment $/kg applicable for Year 1 Extra Investment needed in Year 2 in $ millions) Cost of goods sold $/kg excluding depreciation and delivery 0.11 0.05 0.07 0.10 1.0 4.58 1.5 2.35 1.2 2.52 1.0 2.48 cost 70% 30% 65% 35% Raw material and packing cost (% within COGS) Other costs (% within COGS) Annual delivery cost from VN to PH Annual overhead cost % of net revenue Annual advertisement cost % of net revenue 65% 65% 35% 35% 0.3% Gross Revenue 10% 10% 10% 10% 10% 10% 10% 10% 22,845 22,885 Exhibit 2: Additional information Exchange Rates for the USD as of 31/03/2022 (USD/VND) Bid Rate on USD Ask Rate on USD Inflation Rates (effective annual rates) Vietnam Average CPI Inflation in 2021 Vietnam Average CPI Inflation in 3 months of 2022 Philippines Average CPI Inflation in 2021 Philippines Average CPI Inflation in 3 months of 2022 3 1.84% 2.41% 3.90% 3.40%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Finance With Excel

Authors: Simon Benninga, Tal Mofkadi

3rd Edition

0190296380, 9780190296384

More Books

Students also viewed these Finance questions