Please show step by step explanation in excel

Saint Leo Corporation (a U.S.-based company) has a wholly-owned subsidiary in Vietnam that manufactures insulated wire at a cost of $3 per meter. Saint Leo Corporation imports the insulated wire and sells it to U.S. retailers at a price of $12 per meter. The following information applies: Import duties are levied on the invoice price and are deductible for income tax purposes. The Vietnam subsidiary must repatriate 100 percent of after-tax income to Saint Leo Corp. each year. Saint Leo Corp. has determined an arm's-length range of reliable transfer prices to be