An investor based in USA collects currencies around the world. The investor has a stock of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
An investor based in USA collects currencies around the world. The investor has a stock of several currencies. Of particular interest are Euro, Canadian Dollars and Bitcoin. Answer the questions below by preparing a professional looking report. Do not forget to write your name and a creative title on your report Go to finance.yahoo.com. At the search bar on top type EURO, Bitcoin and Canadian Dollar one at a time. Pick EUR/USD (EURUSD=X), Bitcoin USD (BTC-USD), Canadian Dollar Futures, Mar-202 (6C=F) if you see multiple options. Then scroll down and pick 'History Data'. On the choices, choose Frequency: 'Weekly' and Time Period: '1 year' (1Y). Click the blue Apply button and the download icon underneath. This will download a .csv format Excel file. Open this file in Excel. You will see that this file has 7 columns. We are interested only in the 'date' and the 'close' columns. These indicate at what value the currency closed the day on each Monday within the past year. The value is indicated in US Dollars. Inside Excel: Print a graph of how each currency changed within the last year Part3: (40 pts) Decision making to sell The investor decided to sell a combination of his/her collected Euro, Canadian Dollar and Bitcoin currencies. In exchange, (s)he will receive US dollars. However there are fair trade limitations in North America. According to these limitations, you can only make a single transaction daily. In that transaction, the limitation for these 3 currencies are as follows. You can sell at most 10 Bitcoins a day You can sell at most 500 Euros a day You can sell at most 1000 Canadian Dollars a day The Canadian dollars to sell must be less than or equal to Euros to sell Altogether, you can sell at most a total number of 1500 currencies a) Assuming that the closing currency rates of Feb 15th 2021 are valid when the investor performs the selling transaction, how many Euros, Canadian dollars and Bitcoins should the investor sell to maximize his/her profit in terms of US dollars? b) Define your decision variables, the objective function, constraints and interpret the result. c) What is the revenue in US dollars from this transaction? d) If the investor wants to write to his/her congress representative to place a new policy to increase the bounds of the fair trade by a single unit in one of these 3 currencies, which currency (s) he should choose? Justify your answer with evidence. An investor based in USA collects currencies around the world. The investor has a stock of several currencies. Of particular interest are Euro, Canadian Dollars and Bitcoin. Answer the questions below by preparing a professional looking report. Do not forget to write your name and a creative title on your report Go to finance.yahoo.com. At the search bar on top type EURO, Bitcoin and Canadian Dollar one at a time. Pick EUR/USD (EURUSD=X), Bitcoin USD (BTC-USD), Canadian Dollar Futures, Mar-202 (6C=F) if you see multiple options. Then scroll down and pick 'History Data'. On the choices, choose Frequency: 'Weekly' and Time Period: '1 year' (1Y). Click the blue Apply button and the download icon underneath. This will download a .csv format Excel file. Open this file in Excel. You will see that this file has 7 columns. We are interested only in the 'date' and the 'close' columns. These indicate at what value the currency closed the day on each Monday within the past year. The value is indicated in US Dollars. Inside Excel: Print a graph of how each currency changed within the last year Part3: (40 pts) Decision making to sell The investor decided to sell a combination of his/her collected Euro, Canadian Dollar and Bitcoin currencies. In exchange, (s)he will receive US dollars. However there are fair trade limitations in North America. According to these limitations, you can only make a single transaction daily. In that transaction, the limitation for these 3 currencies are as follows. You can sell at most 10 Bitcoins a day You can sell at most 500 Euros a day You can sell at most 1000 Canadian Dollars a day The Canadian dollars to sell must be less than or equal to Euros to sell Altogether, you can sell at most a total number of 1500 currencies a) Assuming that the closing currency rates of Feb 15th 2021 are valid when the investor performs the selling transaction, how many Euros, Canadian dollars and Bitcoins should the investor sell to maximize his/her profit in terms of US dollars? b) Define your decision variables, the objective function, constraints and interpret the result. c) What is the revenue in US dollars from this transaction? d) If the investor wants to write to his/her congress representative to place a new policy to increase the bounds of the fair trade by a single unit in one of these 3 currencies, which currency (s) he should choose? Justify your answer with evidence.
Expert Answer:
Answer rating: 100% (QA)
Investor Currency Diversification Report By Bard Executive Summary This report analyzes the historic... View the full answer
Related Book For
Financial Reporting and Analysis
ISBN: 978-0078025679
6th edition
Authors: Flawrence Revsine, Daniel Collins, Bruce, Mittelstaedt, Leon
Posted Date:
Students also viewed these finance questions
-
You have been provided with the description of a programming language, J, intended for scripting applications. Its syntax is similar to a cut-down version of Java in that it consists of function...
-
Lakefield Corporations oil trading desk buys and sells oil products (crude oil and refined fuels), options, and futures in international markets. The trading desk is responsible for buying raw...
-
The U.S. Environmental Protection Agency (EPA) requires owners of municipal solid waste land lls to demonstrate that they are nancially capable of satisfying the costs of closing and subsequently...
-
Draw an ER model according to the below information. NOTE: Use a word or any website to produce the diagrams. Dont use handwriting. In ERD diagram: 1. Entity: There are 6 Entity in this diagram:...
-
Pamela borrowed $15 000.00 for investment purposes on March 12 on a demand note providing for a variable rate of interest and payment of any accrued interest on December 31. She repaid $1500.00 on...
-
Archie Co. purchased a framing machine for $45,000 on January 1, 2016. The machine is expected to have a four-year life, with a residual value of $5,000 at the end of four years. Using the...
-
Northern Communications Inc. has two divisions (Individual and Business) and has the following information available for the current year: Northern Communications Inc.s Business segment income is a....
-
Mary Palmquist, a Wall Street securities analyst, wants to determine the relationship between Chile's gross domestic product (GDP) and the profits (after taxes) of the Carlton Company. She obtains...
-
A biologist needs to estimate the weight of all spiny lobsters on the Treasure Coast. To achieve this, the biologist collects a random sample of 20 spiny lobsters. The weights of each lobster in the...
-
7. 8. 9. An experiment is conducted using a fin as shown below. Temperature readings are collected along the length of the fin, which is made from copper with k-400W/m.K. Tb=50C x1 X L = 0.5m x2 h x3...
-
How do similes operate as elements of intertextuality within literary works, establishing intertextual dialogues and echoing motifs, themes, and images from other texts, thereby enriching the texture...
-
Selected operating data for two divisions of Outback Brewing, Ltd., of Australia are given below: Sales Average operating assets Division Queensland $ 1,984,000 $ 620,000 New South Wales $ 2,907,000...
-
2) Consider the function f(x) = x + cos(x) on the interval [0,3] a) Approximate a root off using the method of false position by giving a table of p for n 0,1,.,7. b) Approximate a root of f usig...
-
1 . Compare and contrast the following proposed approaches for dealing with international differences in accounting, disclosure, and auditing standards: ( 1 ) reciprocity, ( 2 ) reconciliation, and (...
-
As part of her year-end responsibilities, Helen prepared the company's variable costing income statement as follows. Sales Variable expenses: $447,200 COGS $172,000 Operating expenses 17,200 189,200...
-
Gary King owns a garage and is contemplating purchasing a tire retreading machine for $25,820. After estimating costs and revenues, Gary projects a net cash inflow from the retreading machine of...
-
The following data (in thousands of dollars) have been taken from the accounting records of Karlana Corporation for the year just ended. Sales$910Raw materials inventory, beginning$80Raw materials...
-
Problem 3.5 (4 points). We will prove, in steps, that rank (L) = rank(LT) for any LE Rnxm (a) Prove that rank (L) = rank (LTL). (Hint: use Problem 3.4.) (b) Use part (a) to deduce that that rank(L) =...
-
Gil Corporation has current assets of $90,000 and current liabilities of $180,000. Required: Compute the effect of each of the following independent transactions on Gils current ratio: 1. Refinancing...
-
Blago Wholesale Company began operations on January 1, 2014, and uses the average cost method in costing its inventory. Management is contemplating a change to the FIFO method in 2015 and is...
-
Following is a list of items taken from the December 31, 2014, balance sheet of Reagan Company (amounts omitted): Accounts payable Accrued expenses Accumulated depreciationbuildings Accumulated...
-
Feng Company installs a computerized manufacturing machine in its factory at the beginning of the year at a cost of $42,300. The machines useful life is estimated at 10 years, or 363,000 units of...
-
In early January 2004, LabTech purchases computer equipment for $147,000 to use in operating ac tivities for the next four years. It estimates the equipments salvage value at $30,000. Prepare tables...
-
Cemer Manufacturing purchases a large lot on which an old building is located as part of its plans to build a new plant. The negotiated purchase price is $225,000 for the lot plus $120,000 for the...
Study smarter with the SolutionInn App