Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

USE MS EXCEL to forecast your foreign sales and earnings in foreign currencyfor 2023 and forecast for next four years using the variables given in

USE MS EXCEL to forecast your foreign sales and earnings in foreign currencyfor 2023 and forecast for next four years using the variables given in the table below. Prepare a forecastedcash flow from 2023 to 2027.

I need a MS excel table as an answer

Growth rate of sales-5% pa

Growth rate of sales price-2% pa+inflation rate

Growth rate of variable costs-inflation rate

Growth rate of fixed costs-inflation rate

Amount of local financing- 1239000000 PHP

Interest rate on local financing- 7.6%

Host country tax rate- 25%

Withholding tax on remitted funds-6%

Yearly exchange rate- 41.3

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

Dynamic Asset Allocation With Forwards And Futures

Authors: Abraham Lioui , Patrice Poncet

1st Edition

0387241078,038724106X

More Books

Students also viewed these Finance questions