Assume today is March 16, 2016. Natasha Kingery is 30 years old and has a Bachelor of Science degree in computer science. She is currently employed as a Tier 2 field service representative for a telephony corporation located in Seattle, Washington, and earns $38,000 a year that she anticipates will grow at 3% per year. Natasha hopes to retire at age 65 and has just begun to think about the future.

Natasha has $75,000 that she recently inherited from her aunt. She invested this money in 30-year Treasury Bonds. She is considering whether she should further her education and would use her inheritance to pay for it.

If Natasha lacked the cash to pay for her tuition upfront, she could borrow the money. More intriguingly, she could sell a fraction of her future earnings, an idea that has received attention from researchers and entrepreneurs; see M. Palacios, Investing in Human Capital: A Capital Markets Approach to Student Funding, Cambridge University Press, 2004

She has investigated a couple of options and is asking for your help as a financial planning intern to determine the financial consequences associated with each option. Natasha has already been accepted to both of these programs, and could start either one soon.

One alternative that Natasha is considering is attaining a certification in network design. This certification would automatically promote her to a Tier 3 field service representative in her company. The base salary for a Tier 3 representative is $10,000 more than what she currently earns and she anticipates that this salary differential will grow at a rate of 3% a year as long as she keeps working. The certification program requires the completion of 20 Web-based courses and a score of 80% or better on an exam at the end of the course work. She has learned that the average amount of time necessary to finish the program is one year. The total cost of the program is $5000, due when she enrolls in the program. Because she will do all the work for the certification on her own time, Natasha does not expect to lose any income during the certification.

Another option is going back to school for an MBA degree. With an MBA degree, Natasha expects to be promoted to a managerial position in her current firm. The managerial position pays $20,000 a year more than her current position. She expects that this salary differential will also grow at a rate of 3% per year for as long as she keeps working. The evening program, which will take three years to complete, costs $25,000 per year, due at the beginning of each of her three years in school. Because she will attend classes in the evening, Natasha doesn't expect to lose any income while she is earning her MBA if she chooses to undertake the MBA.

1.Determine the interest rate she is currently earning on her inheritance by going to the U.S. Treasury Department Web site (treasury.gov) and selecting "Data" on the main menu. Then select "Daily Treasury Yield Curve Rates" under the Interest Rate heading and enter the appropriate year, 2016, and then search down the list for March 16 to obtain the closing yield or interest rate that she is earning. Use this interest rate as the discount rate for the remainder of this problem.

As of March 16, 2016 Natasha, is currently earning 2.73% for a 30-year Interest Rate according to the U.S. Treasury Department Web site (treasury.gov).

2.Create a timeline in Excel for her current situation, as well as the certification program and MBA degree options, using the following assumptions:

a.Salaries for the year are paid only once, at the end of the year.

b.The salary increase becomes effective immediately upon graduating from the MBA program or being certified. That is, because the increases become effective immediately but salaries are paid at the end of the year, the first salary increase will be paid exactly one year after graduation or certification.

3.Calculate the present value of the salary differential for completing the certification program. Subtract the cost of the program to get the NPV of undertaking the certification program.

4.Calculate the present value of the salary differential for completing the MBA degree. Calculate the present value of the cost of the MBA program. Based on your calculations, determine the NPV of undertaking the MBA.

5.Based on your answers to Questions 3 and 4, what advice would you give to Natasha? What if the two programs are mutually exclusive? That is, if Natasha undertakes one of the programs there is no further benefit to undertaking the other program. Would your advice be different?

My advice for Natasha based on the NPV results would be for Natasha to select the MBA program. The MBA program's NPV is $600,783.60 versus $352,035.77 from the certification program. If the two programs were mutually exclusive then my advice would be for her to choose the MBA program, this recommendation is based on her achieving a managerial position upon completion along with a raise of $20,000 and a 3% annual pay increase.

Question 4 Program 4 Complete the create_word_lengths_dictionary() function. This function takes a list of words as a parameter and creates a dictionary of word lengths. Each dictionary item will contain a key of the word length and the corresponding value will be a list of all the words of that length. Parameters: A list of words. Returns: A dictionary where each key-value pair consists of a word length (key) and the corresponding list of words of that length (value). The list of words needs to be sorted in alphabetical order. Some examples of the create word lengths_dictionary () function being used are shown as follows. Note: You do not have to implement the print_dict () function which prints out the key-value pairs of a dictionary such that the keys are sorted in ascending/alphabetical order. This function has been provided for you.Question 1 Print the messages below without using variables. Output must be 2 lines identical to below: What is the snake's favorite language? "I love Python", said the snake. Question 2 Write a python statements to match the 5 lines of output below. Use a single print statement to produce the list of 4 languages The 3 most popular programming languages of 2020 are: 1. Python 2. Javascript 3. Java 4. C#Question 6 (of 6) CO Home Team Corporation recently hired Steve Willits as its bookkeeper. Mr. Willits is somewhat inexperienced and has made numerous errors recording daily business transactions. Indicate the effects of the errors described below on each of the financial statement elements shown in the column headings. Use the following symbols: O for overstated; U for understated, and NE for no effect. Error Net Income Total Ass Recorded the issuance of capital stock by dobiting Capital Stock and crediting Cash Recorded the declaration and payment of a dividend by debiting Interest Expense and crediting Cash. Recorded the payment of an account payable by debiting Cash and crediting Service Revenue. Recorded the collection of an outstanding account receivable by debiting Cash and crediting Accounts Payable. Recorded client billings on account by debiting Service Revenue and crediting Cash. Recorded the cash purchase of land by debiting Cash and crediting Land Recorded the purchase of a building on account by debiting Rent Expense and crediting Capital Stock. Filter the data so that you can separate the number of exercise days for female students and the number of exercise days for male students. (There is nothing to submit for this part.) . Use Excel to compute the summary statistics for each sample. Since you will use these values in calculations. write x and s with four decimals. For this part. submit only the completed table. . Identify whether the two samples are independent or dependent. Provide an explanation. . Use the sample data to construct a 95% condence interval by hand to estimate the mean difference of the exercise days between female students and male students. Show your work. including all calculations. . Check your answer for part d. using the Brock Excel calculator. Submit a screenshot of that sheet. including all input values and output results. Report the 95% condence interval with three decimal places. Interpret this condence interval in the context of the problem. . Does the condence interval suggest there is a difference between the number of days that female MATH 1P98 students exercise and the number of days that male MATH 1P93 students exercise? Explain how you know. If there is a difference. identify which group exercises on more days. on average. (don't write anything down while you are engaged with the other students). If you get anything from the web, give references. Packing simulation Consider the following stochastic process: a start with an empty (1 D) array of length n (i.e. filled with 0) . as long as possible (see below), 0 check to see if any of the empty elements can be filled (see below) 0 pick a random empty (0) element of the array 0 if there is no filled (1) element within radius r of the chosen element, fill it. For example, if r :1 then the elements immediately to the left and right need to be em pty; if r =2 then two elements on each side should be empty (boundaries count as empty, e.g. if you pick element 0 of the array then you only need to consider elements from 1 to r) o othenNise try again a return the fraction of the array that is full Write the following functions: 0 fillab1e(i,a,r=1) : returns a Boolean that says whether element i of array a can be filled (i.e. whether i and all elements within distance r are empty). Make sure to account for boundaries! - any_fi11able(a, r=1) : returns a Boolean that says whether any elements of array a can be filled - fill_one(a,r=1) : fills a single element of a by picking random empty elements until it finds one that can be filled. Returns None (modifies the array a). fill_one() can assume that any_fi11ab1e( ) is True . . fill_sim(n,r=1) : creates an array of length n and fills it until there are no fillable spaces left; returns the filled array . count_sim(n, r=1) : calls fill_sim and computes the proportion of filled spaces in the resulting array Create a 2dimensional array with 10 rows and 20 columns. Fill it with the results of fill_sim( ) for radii from 1 to 10 and array sizes from 15 to 49. Create a plot that displays the contents of the array (probably using matplotlib.pyplot .plot( ) ). Submit your code in the drobox as macid_proj_package.py and your plot as macid_proj_package. png