- Imported live USD to INR exchange rate data into Excel for analysis from Yahoo Finance.
- Used the VLOOKUP formula to map rates over 6 months to help optimize money transfers.
- Built interactive charts and tables to visualize fluctuating currency exchange rates.
- Performed what-if analysis modelling different transfer frequencies and amounts.
- Recommended ideal transfer options to maximize profit and minimize losses.
This Excel model helps Indian parents/students to transfer money any day by evaluating the same day Dollar value with the past six months' values and also future Dollar INR fluctuating rates.