Cars and Bitcoin Assume you own a store selling cars for a large, international car manufacturer. For every car sold, you must pay the car manufacturer 0.95 million Norwegian kroner. NOK denotes Norwegian kroner, and mNOK millions of Norwegian kroner. The sales price of a car is fixed at 1 mNOK. There is a delay between when a customer agrees to buy a car and when the car is delivered and the customer makes the payment for the car. The car manufacturer has decided that customers may pay for the cars using Bitcoin (BTC). Assume that all customers choose to pay in BTC. When you sell a car, you will use the current NOK/BTC exchange rate to fix the amount to be paid in BTC. At delivery of the car, you receive funds in BTC from the customer, and immediately exchange these for NOK at the prevailing exchange rates. This implies that your company is exposed to some currency risk in the time period between the contract is signed and the payment is made. No financial instruments are available to offset this risk. In this home exam, we will use historical data to measure profits over time. Ignore taxes, interest rates and other cost/income related variables except those explicitly asked for in the questions

Problem 2

Assume you sell one car every single day (including holidays and weekends), and that there is a 30-day time difference from when a contract is signed to when the payment for the car is made (lead time). Draw a histogram over the realized profits in NOK (or mNOK) of each car sale. Print out the profit made from selling a car at Jan 03 2021. Show the total cumulative profits if your store had been in operation throughout the data set. Ensure that you account for selling a car every date the last four years. Make a reasonable assumption with respect to potential missing values - e.g. related to missing prices due to holidays and weekends.