Question: please if you can show how to get the answer with what formula(s) and how to input them correctly into excel 2) (10%) Your company

please if you can show how to get the answer with what formula(s) and how to input them correctly into excel

2) (10\%) Your company has $50,000 of additional funds it will need in three months to pay annual employee bonuses. The money is sitting in an account that pays no interest. The company can invest it all into 13 -week ( 91 day) Treasury bills, with a discount rate of 0.185%. A. How much of the investment will the government utilize? B. How much total interest will the company earn on the funds? C. How much money will the government pay back to your company at maturity

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

I need help with part 13. i keep messing up on it and dont think im doing it corrctly. i am using excel 2016 by looking 30 people nnar,tint u by looking 30 people wille .,to 200 people, and beyond...

To whom it may concern is it possible to have the unanswered questions answered? Question 1 0 out of 1 points Which of the following events would make it more likely that a company would choose to...

STAT 200 Final Examination Summer 2016 OL1/US1 Page 1 of 9 STAT 200 Introduction to Statistics Name______________________________ Final Examination: Summer 2016 OL1/US1 Instructor...

STAT 200: Introduction to Statistics Final Examination, Summer 2016 OL1 Page 1 of 7 STAT 200 OL1/US1 Sections Final Exam Summer 2016 The final exam will be posted at 12:01 am on July 8, and it is due...

I'm working on the same project as the attached word document. However, the numbers are a little different. I submitted my project to the professor and he provided this as feedback: "For question 2,...

Crossing Borders: MTC's Journey through Africa You have two choices as a human being: to be a subject of history or a maker of history. We have chosen to belong to the second category. Dr. Saad...

Need answers. Please help. Assignment attached. Navigational Training Navy NAME:________________________ SURFACE NAVIGATOR/ASSISTANT SURFACE NAVIGATOR PREPARATION ASSIGNMENT Below are various...

You have been asked by the president of your company to evaluate the proposed acquisition of a new spectrometer for the firm's R&D department. The equipment's basic price is $70,000 and it would cost...

Please explain all calculations and how you get the answer. if doing it on excel, show rows and columns which are multiplying 2. (10 points) Assume you are asked to find the average price and average...

I need chapters 18, 19, 20, and 21 for the workbook for Personal Finance by Madura!! Please help!!! Personal Finance, Fifth Edition by Jeff Madura BUILDING YOUR OWN FINANCIAL PLAN WORKBOOK INDEX...

As an assistant in the Human Resources Department of a large corporation, you and your department are preparing to honor outstanding employees at an awards ceremony. Three department managers...

Smith Manufacturing Companys accounts receivable clerk has a friend who is also a Smiths customer. The accounts receivable clerk has issued fictitious credit memos to his friend for goods supposedly...

When compared to other creditors, the holder of an unsubordinated debenture has a ( n ) Blank _ _ _ _ _ _ priority claim. Multiple choice question. lower higher equal

5. Develop a scenario comparing two PH programs and involving the use of a CBA.

Teamwork.Technology. Join two of your classmates to research misleading visuals. (a) For one week, each of you will look for visuals that could be misleading. Keep notes of your findings and compile...

Ed Pappas, owner of Pappas Furniture City, has asked you to gather information about energy efficient lighting. Hes interested in learning whether installing energy saving fluorescent bulbs in the...

Celia Stryker and Stan Anthony have hired you to help them promote the opening of their business, the Coffee Cup. The specialty coffee shop is located on the corner of Star Street and Borderline Road...