В работе

Excel Help Needed

Hi, need someone to build this for me please

Sandra Robert

House $200,000 $150,000

Car $20,000 $30,000

Investments $45,000 $56,000

Mortgage -$150,000 -$130,000


(b) Using Excel Help; find the formula for calculating the effective annual interest rate of return.

Syntax: =EFFECT(nominal_rate, npery)

(c) Create a second table and populate the first row with Sandra’s current mortgage balance.

(d) Populate a cell with the mortgage interest rate (7%) and a second cell with the monthly repayment amount ($900).

(e) Design a formula that will populate the rest of Sandra’s repayment schedule, assuming the interest is calculated annually. Make sure the formula uses absolute cell references to refer to the values that you have already created

Навыки: Excel, Обработка данных, Бухгалтерия, Математика, Ввод данных

Показать больше: excel project help needed, excel mysql create table software, vsto excel create table, freelance excel work hourly rate, microsoft excel jobs, remote excel jobs, get paid to make excel spreadsheets, weekend excel jobs, home based excel jobs, freelance excel spreadsheet design, ms excel jobs, web design data table expand row, converting word document table row excel, create web design photoshop table, design examples table excel, excel macro visual basic help needed urgent, access database design create reports excel, php insert excel create table mysql, generate ddl excel create table, dynamically read excel create table sql server

О работодателе:
( 0 отзыв(-а, -ов) ) Melbourne, Australia

ID проекта: #26100775



Hi Sir, Thanks for giving time to see my proposal. I'm Good Typist and worked for many projects in offline. I want to start my career with Online Platform. You can consider me Fresher for Online projects but actually Больше

$10 AUD за 1 день
(0 отзывов(-а))