A company invests 1000000 at the brgining of the year it, Ask an Expert

Finance

A company invests $ 1,000,000 at the brgining of the year. It adds another 250000 at the end of the first quater, withdraws $ 350000 at the end of the second quater adds $ 145000 at the end of the third quater and with draws $ 450000 of the remaining funds at the end of the year. it earns $ 20,000 of interest in the first quater, 17,000 in the second quater, $ 12000 in the third quater and $ 29,000 in the fourth quater.

PLEASE SUBMI THE ANSWER IN EXCEL SPREAD SHEET. CREATE OR WRITE THE FORMULA IN THE SPREAD SHETT AND SHOW YOUR WORK AT ARRIVING AT YOUR SOLUTION

a) What is the annual effective rate earned on the investment portfolio?

b) What rate of return would have been calculated if only looked at the ending portfolio value as compared with the beginning $ 1,000,000 investment?

View complete question

Financial Management, Finance

Category:- Financial Management
Reference No.:- M91825699

Have any Question?Write your Review or question?

Related Questions in Financial Management

Scenariobig data is everywhere and various businesses

Scenario Big Data is everywhere and various businesses around the world are driven by Big Data. However, while some businesses rely on Big Data for organizational decision making, this does not mean that the implications ...

Assignment 1questions answer with 150 words please on one

Assignment 1 Questions answer with 150 words please on one Microsoft word document just answered with question 1 : answer, Question2 : answer, etc... Assignment in its own document Question1: How can a researcher ensure ...

Discussionbull profits and risks of off-balance-sheet

Discussion • Profits and Risks of Off-Balance-Sheet Activities • The difference between spot and forward exchange rates. What role do currency swaps play? • The Federal Open Market Committee • Multiple Deposit Creation a ...

Personal savings strategiespart i identify all the lazy

Personal Savings Strategies Part I: Identify all the lazy dollars in your financial life. Identify source, amount and what action might be indicated. Part II. Develop a personal and household savings plan. What savings s ...

Assignment -complete a research topic and prepare a

Assignment - Complete a research topic and prepare a write-up, and a presentation. SECTION A: Financial Analysis and Pricing Select a portfolio of five firms from the industry of your choice. Please then see me for appro ...

Read through the tree trimming project case in chapter 13

Read through the Tree Trimming Project case in chapter 13 of the textbook. This case refers to the earned value (EV) of the owner, Will Fence's Tree Trimming business. Will briefly describes his techniques for EV. Based ...

Please respond to the following discussion not an essay

Please respond to the following: {Discussion, NOT an Essay. Under 350 WORDS} a) Propose three reforms to the investment markets that might reduce their exposure to systematic risk. Support your proposals with examples. b ...

Special project -text book spreadsheet modeling for

Special project -text book: Spreadsheet modeling for business decisions - 2, 3 or 4th edition 1. A selected Forecast Model showed the lowest MAD at the beginning of the year with $60.5. If the following three quarters re ...

Compare and contrast the various forms of business

Compare and contrast the various forms of business organizations. Decide which structure is best suited for your class project (Massage Day Spa (Partnership)) and indicate why. From the e-Activity, infer what the trends ...

Qestionsforecast 2019 revenue column m by estimating the

Questions: Forecast 2019 revenue (Column M) by estimating the % growth drivers (Column R). Forecast 2019 expenses (Column M) by estimating the expense as % of revenue drivers (Column X). Write your rationale for each ass ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Financial Management Expert