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

Accounting

A company invests $1,000,000 at the beginning of the year. It adds another $250,000 at the end of the first quarter, withdraws $350,000 at the end of the second quarter, adds $145,000 at the end of the third quarter, and withdraws $450,000 of the remaining funds at the end of the year. It earns $20,000 of interest in the first quarter, $17,000 in the second quarter, $12,000 in the third quarter, and 29,000 in the fourth quarter.

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

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

Please show all calculations in an excel spread sheet.

View complete question

Financial Accounting, Accounting

Category:- Financial Accounting
Reference No.:- M91960960

Have any Question?Write your Review or question?

Related Questions in Financial Accounting

Establish and maintain accounting info systems and provide

Establish and maintain accounting info systems and Provide management accounting information Assignment - Assignment 1 - Case Studies Case Study 1 - Review the case study information below and complete the steps mentione ...

Corporate accounting assignment -assessment task -select

Corporate Accounting Assignment - Assessment task - Select two public limited companies listed on the Australian Securities Exchange (ASX) that are in the same industry. Go to the website of your selected companies. Then ...

Asset retirement obligation changes in estimate versus

Asset Retirement Obligation, Changes in Estimate versus Errors, Writing an Issues Memo Facts: Mega¬Corp's corporate headquarters, built in 1970, has asbestos in its insulation. The Company's financial statements reflect ...

Assessment task 1question no 1assessment taskbilby cos

Assessment Task 1 Question no. 1 Assessment Task: Bilby Co's income statement for the year ended 31 December 2015 and statements of financial position at 31 December 2014 and 31 December 2015 were as follows: Bilby co's ...

Exercise 1 copying formatting and calculating sums and

EXERCISE 1: COPYING, FORMATTING, AND CALCULATING SUMS AND AVERAGES Let's assume that Groth Donut Company has three stores, only one of which is shown at the top of the sheet titled "p = r--e". The revenue and expenses f ...

Assignment -part a -background saturn petcare australia and

Assignment - Part A - Background: Saturn Petcare Australia and New Zealand is Australia's largest manufacturer of pet care products. Saturn have been part of the Australian and New Zealand pet care landscape since openin ...

Listed below are selected account balances for pinnacle

Listed below are selected account balances for Pinnacle Corporation at December 31, Year 1 and Year 2. Also available for you is selected information from the income statement for Pinnacle for the year ended December 31 ...

Can you please help me with thishow do restrictions affect

Can you please help me with this. How do restrictions affect net assets in Not- For -Profit organization or health care?

Budgets and managerial responsibilitythis module explores

Budgets and Managerial Responsibility This module explores budgets and the benefits of creating budgets. In recent years, many organizations faced one of the hardest economic conditions with the recession. Many organizat ...

Advanced financial accounting assignment -assessment task

Advanced Financial Accounting Assignment - Assessment Task Part A - In an article entitled 'Unwieldy rules useless for investors' that appeared in the Australian Financial Review on 6 February 2012 (by Agnes King), the f ...

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 Accounting Expert