You are a financial modeling expert who was asked by a client to assist in funding his fixed assets....

You are a financial modeling expert who was asked by a client to assist in funding his fixed assets. The client is a company engaged in cargo services that wants to buy a vehicle and asks you to make a financial model in terms of modeling principal and interest payments, depreciation and cash flow Data provided: 1. The company needs 10 vehicles with an estimated price of 200 million 2. Currently the company has a fund of 500 million 3. The company's ability to repay each month is Rp. 200 million 4. It is known that bank A's interest is 10% 5. By buying 10 vehicles, the company will get a net income of 40 million for each vehicle You are asked: With the available information, you are asked to make a financial modeling with additional assumptions of a modeler in the development of a financial model and then advise the client whether with 200 million per month, what is the best decision the company can make? You are a financial modeling expert who was asked by a client to assist in funding his fixed assets. The client is a company engaged in cargo services that wants to buy a vehicle and asks you to make a financial model in terms of modeling principal and interest payments, depreciation and cash flow Data provided: 1. The company needs 10 vehicles with an estimated price of 200 million 2. Currently the company has a fund of 500 million 3. The company's ability to repay each month is Rp. 200 million 4. It is known that bank A's interest is 10% 5. By buying 10 vehicles, the company will get a net income of 40 million for each vehicle You are asked: With the available information, you are asked to make a financial modeling with additional assumptions of a modeler in the development of a financial model and then advise the client whether with 200 million per month, what is the best decision the company can make