Please help with answers and formulas. Thanks
Homework Answers
Calculation of the same as per given pattern -
| Opening balance | 2500 | 2678.13 | 2856.47 | 3035.04 | 3213.84 | 3392.85 | 3572.10 | 3751.56 | 3931.25 | 4111.16 | 4291.30 | 4471.67 | Total | |
| Annual interest rate | 1.50% | 1.50% | 1.50% | 1.50% | 1.50% | 1.50% | 1.50% | 1.50% | 1.50% | 1.50% | 1.50% | 1.50% | ||
| Income | January | February | March | April | May | June | July | August | September | October | November | December | ||
| Salary | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 18000 | |
| Interest income (opening balance*1.50%*1/12) | 3.13 | 3.35 | 3.57 | 3.79 | 4.02 | 4.24 | 4.47 | 4.69 | 4.91 | 5.14 | 5.36 | 5.59 | 52.26 | |
| Total Income | 1503.13 | 1503.35 | 1503.57 | 1503.79 | 1504.02 | 1504.24 | 1504.47 | 1504.69 | 1504.91 | 1505.14 | 1505.36 | 1505.59 | ||
| Expenses | ||||||||||||||
| Rent | 750 | 750 | 750 | 750 | 750 | 750 | 750 | 750 | 750 | 750 | 750 | 750 | 9000 | |
| Car payment | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 3600 | |
| Utilities | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 900 | |
| Food | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 2400 | |
| Total Expenses | 1325 | 1325 | 1325 | 1325 | 1325 | 1325 | 1325 | 1325 | 1325 | 1325 | 1325 | 1325 | 15900 | |
| Opening balance | 2500.00 | 2678.13 | 2856.47 | 3035.04 | 3213.84 | 3392.85 | 3572.10 | 3751.56 | 3931.25 | 4111.16 | 4291.30 | 4471.67 | ||
| Increase/(Decrease) in savings (Total Income - Total Expenses) | 178.13 | 178.35 | 178.57 | 178.79 | 179.02 | 179.24 | 179.47 | 179.69 | 179.91 | 180.14 | 180.36 | 180.59 | 2152.26 | |
| Ending Balance (opening balannce + Increase /Decrease in savings) | 2678.13 | 2856.47 | 3035.04 | 3213.84 | 3392.85 | 3572.10 | 3751.56 | 3931.25 | 4111.16 | 4291.30 | 4471.67 | 4652.26 | ||
All formulas are given in the headings.If any missed pleae comment.
closing balance of previous month will become opening balance of next month.
In case of any doubt please comment.
Add Answer to:
Please help with answers and formulas. Thanks
Escel Homework Probiem 2 Opening Balance 5 2.500.00 Soutisa...
what formulas would I use to work out these calculations? Please help!! You complete using any...
what formulas would I use to work out these calculations?
Please help!!
You complete using any method you've learnt This is done for you You complete Financial Year Summary Sheet Patron Revenue Total Product Profit Total Staff Cost Gross Profit Monthly Profit Jul-18) Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Monthly Fixed Costs $ 23,800 $ 23,800 $ 23,800 $ 23,800 $ 23,800 $ 23,800 $ 29,500 $ 29,500 $ 29,500 $ 29,500 $ 29,500 $...
PLEASE HELP... NO ONE WILL ANSWER THIS QUESTION. home / study / business / finance / finance questions and answers / con...
PLEASE HELP... NO ONE WILL ANSWER THIS QUESTION. home / study / business / finance / finance questions and answers / consider the monthly returns of ford motor company and general electric shown on the next page. ... Question: Consider the monthly returns of Ford Motor Company and General Electric shown on the next page. A... Consider the monthly returns of Ford Motor Company and General Electric shown on the next page. An Excel spreadsheet with the data is also...
MUST SHOW ALL CELL FORMULAS Required: You need to prepare a comprehensive 12-month budget, including supporting...
MUST SHOW ALL CELL FORMULAS
Required: You need to prepare a comprehensive
12-month budget, including supporting schedules and a report for
the period January 1, 2020 to December 31, 2020 for Hedron,
Inc.
INFORMATION FOR HEDRON, INC.
Hedron, Inc. is a company that re-sells one product, a
particularly comfortable lawn chair. An overseas contractor makes
the product exclusively for Hedron, so Hedron has no manufacturing
related costs.
PRODUCT COSTS
In Nov of 2019, each lawn chair costs
Hedron $4 per...
Hello, I need help with QUESTION 2 ONLY. thanks!! Question: Crazy Cases has a small kiosk...
Hello, I need help with QUESTION 2 ONLY. thanks!! Question: Crazy Cases has a small kiosk in the local mall, they sell cellphone cases and accessories. The c... Crazy Cases has a small kiosk in the local mall, they sell cellphone cases and accessories. The company has the following actual data for 2012, the kiosk opened in early April. Month Production (Units) Overhead Costs Apr 5,000 12,000 May 5,750 16,000 Jun 7,500 18,500 Jul 7,750 19,750 Aug...
Q2. Draw up a cash budget for Amben Ltd showing the balance at the end of...
Q2. Draw up a cash budget for Amben Ltd showing the balance at the end of each month from the following information for the six months ended 31 December 2016. Write a short report on the budget. a. Opening cash balance (including bank) balance $12,200 b. Production in units: April 1,240, May 1,270, June 1,300, July 1,320, August 1,350, Sep 1,370, Oct 1,380, Nov 1,340, Dec 1,310, Jan 2017 1,260, Feb, 1,250. c. Raw materials used in production cost $12...
AutoSaveff File Home InsertPage Layout Formulas Da D1 1 Year Month 2 1 13 17 1 January February 15 4 1 March 511 April 6 1 May 12 32 15 June 1 July 91 August 17 101 September33 15 October 12...
AutoSaveff File Home InsertPage Layout Formulas Da D1 1 Year Month 2 1 13 17 1 January February 15 4 1 March 511 April 6 1 May 12 32 15 June 1 July 91 August 17 101 September33 15 October 12 1 November34 December 21 14 2 January26 15 2 February10 13 1 162 March 17 2 April 18 2 May 14 19 17 14 27 30 222 September25 June 21 2 23 2 25 27 3 29 3 August...
SQL - create statement for query For each patient, display his or her last name, first...
SQL - create statement for query For each patient, display his or her last name, first name, and the name of his or her doctor. For each pediatrics patient, display his or her ID and his or her doctor's ID and name. For each doctor, display the name and the name of the doctor's supervisor in alphabetic order of supervisor's name. Include column aliases for clarity. Note: Check for accuracy. For each doctor in one of the two areas entered...
I just need you to answer the last two that's not answer. please can you show...
I just need you to answer the last two that's not
answer. please can you show your work. I also will make sure to
give u a thumbs up for you hard work. thanks. again I only need the
last 2 that's not answer, I need those answersed.
Question Help Updating Salary Survey Data As a newly hired compensation analyst, you've been asked by the Director of Compensation to assist with the preparation of next year's compensation plan for accounting...
Need Assistance on Closing Entries. If more info is needed please let me know Trial Balance...
Need Assistance on Closing Entries. If more info is needed
please let me know
Trial Balance
Particulars
Debit
Credit
Cash/Bank
$ 441,730.00
Notes recievable
$
-
Accounts recievable
$ 78,866.00
Interest Received
$
410.00
Doubtfull debts
$
2,930.00
Bad debts
$ 11,134.00
Inventories
$ 65,000.00
Prepaid utilities
$ 18,000.00
Utilities Expense
$ 12,000.00
office supplies
$
-
Supplies expense
$
8,000.00
Prepaid insurance
$
-
$
4,260.00
Rent
$ 29,800.00
Prepaid rent
$
5,000.00
Investment in securities
$ 180,000.00
Land...
Scenario: Styles Wing Bicycle Company manufactures and sells 2 sizes of bicycles, 21.5 inch and 22.5...
Scenario: Styles Wing Bicycle Company manufactures and sells 2 sizes of bicycles, 21.5 inch and 22.5 inch. Sales Their sales team has committed to the following projected monthly unit sales for the next year. Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov 21.5 Bike 368 472 633 616 443 345 322 317 317 317 328 22.5 Bike 320 410 550 535 385 300 280 275 275 275 285 Dec 420 365 The selling price for the 21.5...
what formulas would I use to work out these calculations?
Please help!!
You complete using any method you've learnt This is done for you You complete Financial Year Summary Sheet Patron Revenue Total Product Profit Total Staff Cost Gross Profit Monthly Profit Jul-18) Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Monthly Fixed Costs $ 23,800 $ 23,800 $ 23,800 $ 23,800 $ 23,800 $ 23,800 $ 29,500 $ 29,500 $ 29,500 $ 29,500 $ 29,500 $...
MUST SHOW ALL CELL FORMULAS
Required: You need to prepare a comprehensive
12-month budget, including supporting schedules and a report for
the period January 1, 2020 to December 31, 2020 for Hedron,
Inc.
INFORMATION FOR HEDRON, INC.
Hedron, Inc. is a company that re-sells one product, a
particularly comfortable lawn chair. An overseas contractor makes
the product exclusively for Hedron, so Hedron has no manufacturing
related costs.
PRODUCT COSTS
In Nov of 2019, each lawn chair costs
Hedron $4 per...
AutoSaveff File Home InsertPage Layout Formulas Da D1 1 Year Month 2 1 13 17 1 January February 15 4 1 March 511 April 6 1 May 12 32 15 June 1 July 91 August 17 101 September33 15 October 12 1 November34 December 21 14 2 January26 15 2 February10 13 1 162 March 17 2 April 18 2 May 14 19 17 14 27 30 222 September25 June 21 2 23 2 25 27 3 29 3 August...
I just need you to answer the last two that's not
answer. please can you show your work. I also will make sure to
give u a thumbs up for you hard work. thanks. again I only need the
last 2 that's not answer, I need those answersed.
Question Help Updating Salary Survey Data As a newly hired compensation analyst, you've been asked by the Director of Compensation to assist with the preparation of next year's compensation plan for accounting...
Need Assistance on Closing Entries. If more info is needed
please let me know
Trial Balance
Particulars
Debit
Credit
Cash/Bank
$ 441,730.00
Notes recievable
$
-
Accounts recievable
$ 78,866.00
Interest Received
$
410.00
Doubtfull debts
$
2,930.00
Bad debts
$ 11,134.00
Inventories
$ 65,000.00
Prepaid utilities
$ 18,000.00
Utilities Expense
$ 12,000.00
office supplies
$
-
Supplies expense
$
8,000.00
Prepaid insurance
$
-
$
4,260.00
Rent
$ 29,800.00
Prepaid rent
$
5,000.00
Investment in securities
$ 180,000.00
Land...
Scenario: Styles Wing Bicycle Company manufactures and sells 2 sizes of bicycles, 21.5 inch and 22.5 inch. Sales Their sales team has committed to the following projected monthly unit sales for the next year. Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov 21.5 Bike 368 472 633 616 443 345 322 317 317 317 328 22.5 Bike 320 410 550 535 385 300 280 275 275 275 285 Dec 420 365 The selling price for the 21.5...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago